https://bugs.freedesktop.org/show_bug.cgi?id=77039
Priority: medium
Bug ID: 77039
Assignee: [email protected]
Summary: COUNTIF doesn't count a blank cell from formula on LO
4.2
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96884
--> https://bugs.freedesktop.org/attachment.cgi?id=96884&action=edit
COUNTIF doesn't count blank cells from formulas
Instead of COUNTBLANK, I used COUNTIF function to count blank cells from
formulas on LibreOffice 4.1, because COUNTBLANK cannot count them.
However after updating from 4.1.4 to 4.2.2, the formula always returns "0".
See the attached document and check cell B9 ...=COUNTIF($B$3:$B$8,"")
COUNTIF returns "0" on LO 4.2, though the correct answer is "4".
As a workaround on LO 4.2, I use SUMPRODUCT function temporarily,
=SUMPRODUCT(($B$3:$B$8="")*1)
The same problem occers with SUMIF function.
(Check cell F9 in attached document)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
