[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 #9 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Mike Kaganski from comment #8)

> =SUMPRODUCT(A2:A7;B2:B7<>"";B2:B7<>0)
will not work with excel (result is 0)

> =SUMIFS(A2:A7;B2:B7;"<>0";B2:B7;"<>")
will work with excel too (result 13)

can we assign this issue to eike and regina for review?

-- 
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/188305c4/attachment-0001.html>