WD.AVERAGEIFS
Description
Returns the average of the values that meet multiple conditions (criteria). This function
is the same as AVERAGEIFS but WD.AVERAGEIFS creates an index (b-tree) for the specified
ranges/arrays. This function provides better performance for repeated use on the same
range/array. Null and error values are ignored.
Syntax
WD.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/array 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.