COUNTIFS function


DESCRIPTION:

Count cells that match multiple criteria.

 

SYNTAX:

=COUNTIFS( criteria_range1, criteria1[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.