AVERAGEIFS

AVERAGEIFS(arg1, arg2, arg3, arg4, arg5) → { number }

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

Parameters:

Name Type Description
arg1 ApiRange

The range of cells which will be evaluated.

arg2 number | string

The first 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.

arg4 number | string

Up to 127 additional conditions or criteria in the form of a number, expression, or text that defines which cells will be used to find the average. These arguments are optional.

arg5 ApiRange

Up to 127 actual ranges to be used to find the average. If omitted, the cells in the range are used. These arguments are optional.

Returns:

Type
number