https://bugs.freedesktop.org/show_bug.cgi?id=58689
Priority: medium
Bug ID: 58689
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Countifs formula does not count blanks
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: crusader...@gmail.com
Hardware: PowerPC
Status: UNCONFIRMED
Version: 4.0.0.0.beta2
Component: Spreadsheet
Product: LibreOffice
Created attachment 72040
--> https://bugs.freedesktop.org/attachment.cgi?id=72040&action=edit
Spreadsheet showing failure of Countifs to count blanks
The following formula does not count blanks:
=COUNTIFS(C1:C10,"Good",B1:B10,"Dairy",D1:D10,"")
This formula returns a value of zero. The correct value should be 1 (one).
This formula was tested in Excel and returned the correct value of one.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
