https://bugs.documentfoundation.org/show_bug.cgi?id=94149
--- Comment #4 from m.a.riosv <[email protected]> --- c44: =IF(COUNT(WeeklyRounds.C44:$AMC44)>19;"";IF(SUM(WeeklyRounds.C44:$AMC44)>0;SUM(WeeklyRounds.C44:$AMC44);"")) Into the formula COUNT(WeeklyRounds.C44:$AMC44) is equal 17 So the sum is calculated and showed because is higher than zero. bh29: =IF(COUNT(WeeklyRounds.BH29:$AMC29)>19;"";IF(SUM(WeeklyRounds.BH29:$AMC29)>0;SUM(WeeklyRounds.BH29:$AMC29);"")) Into the formula COUNT(WeeklyRounds.BH29:$AMC29) is equal 19 So the sum is calculated and showed because is higher than zero. I guess you know analyzed rows has values higher than one, so the SUM is not equal than COUNT. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
