https://bugs.freedesktop.org/show_bug.cgi?id=58689
--- Comment #6 from Crusader <crusader...@gmail.com> --- (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, -- 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