AVERAGEIF

AVERAGEIF(arg1, arg2, arg3) → { number }

Finds the average (arithmetic mean) for the cells specified by a given condition or criteria.

Parameters:

Name Type Description
arg1 ApiRange

The range of cells which will be evaluated.

arg2 number | string

The condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average.

arg3 ApiRange

The actual cells to be used to find the average. If omitted, the cells in the range are used.

Returns:

Type
number