[Libreoffice-bugs] [Bug 112115] COUNTIF not counting non-blank cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Your formula does not count non-blank cells, it ("<>""") counts cells where the
content is unequal to " a double quote. Note that within an inline literal
string constant two double quotes "" represent one escaped double quote.

5.4 changed how empty cells are treated, ie. they are counted for "equals
empty" ("=") or "not-equals not-empty" ("<>X") like other spreadsheet
applications do.

To count non-empty cells your formula should have "<>" as criteria argument,
eg. =COUNTIF(D24:N24,"<>")
Or compare to Y in your case, =COUNTIF(D24:N24,"=Y")

-- 
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/20170830/781552e3/attachment-0001.html>