https://bugs.documentfoundation.org/show_bug.cgi?id=99291
--- Comment #2 from Jerzy Tyszkiewicz <[email protected]> --- (Same version as initailly) COUNTIFS, SUMIF, SUMIFS, AVERAGEIFS display the same behaviour. Surprisingly enough, AVERAGEIF behaves as it is supposed to, ignoring rows with blanks even if the criteria range contains blanks. However, it does not work correctly, either. If the context is as follows: Column A: blank;1 Column B: 1;2 then the formulas =AVERAGEIF(B1:B2;A1:A2;A1) =AVERAGEIF(B1:B2;A1:A2;A2) compute #DIV/0!;1 while {=AVERAGEIF(B1:B2;A1:A2;A1:A2)} computes #DIV/0!; #DIV/0! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
