COUNTIFS function

description:

Count cells that match multiple criteria.

 

syntax:

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