ReferenceFunctionsMath Functions
AVERAGE
AVERAGE: Returns the arithmetic mean of numeric values across scalars and ranges.
Summary
AVERAGE sums numeric inputs and divides by the count of numeric values that participated.
Remarks
- Errors in any scalar argument or referenced range propagate immediately.
- In ranges, only numeric/date-time serial values are included; text and blanks are ignored.
- Scalar arguments use lenient number coercion with locale support.
- If no numeric values are found,
AVERAGEreturns#DIV/0!.
Examples
Average of scalar values
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
11.666666666666666
Average over a mixed range
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
15
No numeric values returns divide-by-zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!
Related functions
FAQ
When does AVERAGE return #DIV/0!?
It returns #DIV/0! when no numeric values are found after filtering/coercion.
Do text cells in ranges affect the denominator?
No. Only numeric values are counted toward the divisor.
Runtime metadata
Category
Math
Signature
AVERAGE(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLYSTREAM_OK
Source