Forum Discussion
COUNTIFS function
When trying to count the number of cells containing one and the second value, the function returns 0 a a a b b c c c =COUNTIFS(A1:A8;"a";A1:A8;"b")
A couple of alternatives:
=COUNTIF(A1:A8,"a")+COUNTIF(A1:A8,"b")
=SUM(COUNTIFS(A1:A8,{"a","b"}))