WD.AVERAGEIF
Description
Returns the average of the values that meet the specified condition (criterion). This
function is the same as AVERAGEIF but WD.AVERAGEIF creates an index (b-tree) for the
specified range or array. This function provides better performance for repeated use on the
same range/array. Null and error values are ignored.
Syntax
WD.AVERAGEIF(
range
,
criteria
, [
average_range
])
- 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.
- 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.