COUNT IF and COUNT IFS

Hi Kate, thanks for your query. COUNTIF only counts those values in a single column that match a certain criteria. But consider:

A B
1 a
2 b
3 c
4 b
2 b

How would you count only those cells where the values are 2 and b, in the separate columns? Two separate COUNTIF fomulas and then add the results? You could use the COUNTIFS function to do so instead:

=COUNTIFS(A1:A5, "2", B1:B5, "b")

Basically, we talking multiple criteria checking. You can also do this with the array formulas I mentioned.

Hope this helps,

Anthony