[Libreoffice-bugs] [Bug 130734] COUNTIFS function not evaluating correctly when not only checking for equality
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Feb 17 13:44:27 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=130734
Eike Rathke <erack at redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #1 from Eike Rathke <erack at redhat.com> ---
The result 2 in A9 is correct. The formula is
=COUNTIFS($A$2:$A$5; "foo"; $B$2:$B$5;"<>''")
The Criteria "<>''" matches all cells where the content is not the literal
string '' (two consecutive appostrophes). The "''" does *not* denote an empty
string. If you wanted to match non-empty cells then the Criteria argument
should be "<>", i.e. only the <> operator without further value.
I don't recall what 5.9 may have done there, but if the result was 1 in that
case then it was wrong. There was some bug with the IFS() function.
--
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/20200217/91dcf6f1/attachment.htm>
More information about the Libreoffice-bugs
mailing list