AVERAGE

Returns the numerical average value in a dataset, ignoring text.

Syntax

AVERAGE(value, [value, ...])

• value - The value or range to consider when calculating the average value.

Sample Usage

AVERAGE(A2:A6)
AVERAGE(A2:A6, 5, 10)

Return Value

• The numerical average value in a dataset.

Notes

See Also