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