[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121696

--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Oliver Brinzing from comment #7)
> the "[ ] Treat empty string as zero" compatibility option seems to have no
> influence. is this correct?

Citing bug 73081 comment 0:

> 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 bug 73081 comment 14:

> 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;"<>")

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181126/7eb0fd6a/attachment-0001.html>