AVERAGEIFS
Description
Returns the average of the values that meet multiple conditions (criteria).
Syntax
AVERAGEIFS(
average_range
,
range
,
criteria
, [
range2
,
criteria2
], ...)
- average_range: The values, or the range of cells, to be averaged if the specified ranges meet the specified conditions.
- range: The values, or the range of cells, to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- range2: The values, or the range of cells, to be evaluated according to the condition.
- criteria2: The condition to use to evaluate the values.