COUNTIFS
Description
Returns the number of times that the cells in the specified ranges meet multiple
conditions (criteria). You can use the * wildcard to match string values.
Syntax
COUNTIFS(
range
,
criteria
, [
range2
,
criteria2
], ...)
- range: The value, or list of values, to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- range2: The value, or list of values, to be evaluated according to the condition.
- criteria2: The condition to use to evaluate the values.