COUNTIFS function


Count cells that match multiple criteria.



=COUNTIFS( criteria_range1criteria1[criteria_range2][criteria2], … )


required arguments:

criteria_range1 The first range to check.
criteria1 The criteria to use on criteria_range1.


optional arguments:

[criteria_range2] The second range to check.
[criteria2] The criteria to use on criteria_range2.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.