Courses
COUNTIFS Function
Return value
Returns a count of the number of rows that matches the criteria in criteria ranges.
Syntax
= COUNTIFS(criteria_range1; criteria1; ...)
Arguments
| Arguments | Description |
|---|---|
| criteria_range1 | The range to check if criteria1 matches. |
| criteria1 | The criteria to match in the criteria range. |
| [criteria_range…n] | [Optional]: Up to the limit of 127 of criteria ranges. |
| [criteria…n] | [Optional]: Up to the limit of 127 of criteria. |