AVERAGEIF
Description
Returns the average of the values that meet the specified condition (criterion).
Syntax
AVERAGEIF(
range
,
criteria
, [
average_range
])
- range: The values, or the range of cells, to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- average_range: The values, or the range of cells, to be averaged if the range meets the specified condition. If not specified, the range is averaged.