Summary: | Countifs formula does not count blanks | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Crusader <crusader222> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED INVALID | QA Contact: | |
Severity: | critical | ||
Priority: | high | CC: | cno |
Version: | 4.0.0.0.beta2 | ||
Hardware: | PowerPC | ||
OS: | Windows (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: |
Spreadsheet showing failure of Countifs to count blanks
Spreadsheet showing failure of Countifs to count blanks Spreadsheet text showing failure of Countifs to count blanks |
Sumifs also does not recognize blanks I am not familiar with bug reporting. I uploaded my Calc spreadsheet (in .ods format); however, when I reviewed it on the bug reporting site, it states that the upload was text (and is unreadable). If I can get directions on how to upload the LO Calc spreadsheet, I will be happy to upload it again. Created attachment 72043 [details]
Spreadsheet showing failure of Countifs to count blanks
Created attachment 72090 [details]
Spreadsheet text showing failure of Countifs to count blanks
Yet another attempt to upload a sample spreadsheet to support my report.
Hi crusader, (In reply to comment #0) > =COUNTIFS(C1:C10,"Good",B1:B10,"Dairy",D1:D10,"") Your formula is wrong. Should be something like =COUNTIF(C1:C10;"GOOD")+COUNTIF(C1:C10;"FOO") Apart from that, I'n not aware that blanks (empty strings) should be counted. I expect the user support lists and such, can give you proper advise for that? Thanks, (In reply to comment #5) Thank you for the feedback, Cor Nouws. SUMPRODUCT works perfectly (counts blanks): =SUMPRODUCT(C1:C10="Good",B1:B10="Dairy",D1:D10="") I thought COUNTIFS may do the same... > Hi crusader, > > (In reply to comment #0) > > =COUNTIFS(C1:C10,"Good",B1:B10,"Dairy",D1:D10,"") > > Your formula is wrong. Should be something like > =COUNTIF(C1:C10;"GOOD")+COUNTIF(C1:C10;"FOO") > > Apart from that, I'n not aware that blanks (empty strings) should be counted. > I expect the user support lists and such, can give you proper advise for > that? > Thanks, Hi crusader, Thanks for confirming the better way to do that job ;-) Resolving this issue then & close |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 72040 [details] 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.