COUNTIFS
Counts the number of cells within a range that meet multiple criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Parameters
- criteria_range1: Required. The first range to evaluate
- criteria1: Required. The criteria in the form of a number, expression, or text
- criteria_range2: Optional. Additional ranges
- criteria2: Optional. Additional criteria
Example
=COUNTIFS(A1:A10, ">5", B1:B10, "Yes")