DAVERAGE

DAVERAGE(arg1, arg2, arg3) → { number | string | boolean }

Averages the values in a column in a list or database that match conditions you specify.

Parameters:

Name Type Description
arg1 ApiRange

Is the range of cells that makes up the list or database. A database is a list of related data.

arg2 number

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

arg3 string

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

Returns:

Type
number | string | boolean