<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121696#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121696">bug 121696</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=121696#c7">comment #7</a>) > the "[ ] Treat empty string as zero" compatibility option seems to have no > influence. is this correct? Citing <a class="bz_bug_link bz_status_VERIFIED bz_closed" title="VERIFIED FIXED - COUNTIF with criterium <>number does not count empty cells." href="show_bug.cgi?id=73081#c0">bug 73081 comment 0</a>: > Notice the part "including empty cells". > > Notice, that this is not about the problem, whether a zero-length string is > to be considered as empty cell. So clearly this is the case where empty cells and zero-length-strings cells can be treated differently. > and the question is: which formula's are affected? citing <a class="bz_bug_link bz_status_VERIFIED bz_closed" title="VERIFIED FIXED - COUNTIF with criterium <>number does not count empty cells." href="show_bug.cgi?id=73081#c14">bug 73081 comment 14</a>: > So COUNTIF() is inconsistent and now Calc does the same. Some proper formulas for current state: =SUMPRODUCT(A2:A7;B2:B7<>"";B2:B7<>0) =SUMIFS(A2:A7;B2:B7;"<>0";B2:B7;"<>")</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>