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.
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