COUNTIFS
Counts the number of cells specified by a given set of conditions or criteria.
Syntax
 Copy Code
|
|---|
COUNTIFS( ReferenceOrArray range1, Criterion criteria1, ReferenceOrArray range2, Criterion criteria2, ... ) → Number |
range1 | Required. The first range to evaluate with the associated criteria. |
criteria1 | Required. The criteria to use on the first range. |
range2 | Optional. Additional ranges and their associated criteria. |
criteria2 | Optional. The criteria to use on the second range. |
Each range must have the same number of rows and columns.