https://bugs.documentfoundation.org/show_bug.cgi?id=112115
Bug ID: 112115
Summary: COUNTIF not counting non-blank cells
Product: LibreOffice
Version: 5.4.0.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: neavesphi...@gmail.com
Created attachment 135877
--> https://bugs.documentfoundation.org/attachment.cgi?id=135877&action=edit
Spreadsheet to resolve backups
I have a spreadsheet that counts NON blank cells. It works in 5.3.4.2
but counts ALL cells in 5.4
Syntax example is:
=COUNTIF(D24:N24,"<>""")
I have attached the spreadsheet.
Delete a 'Y' and the counts go up to 11.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs