[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