AVERAGE
The AVERAGE function returns the arithmetic mean of the numbers.
This function is widely used in statistics, data analysis, and everyday calculations to determine the central tendency of a set of numerical values.
Syntax
AVERAGE(value1, [value2, ...])
| Argument | Description | Permitted values |
|---|---|---|
| value1 | First value or range to consider when calculating the average | Numbers, ranges of cells with numbers |
| [value2, ...] | (optional) Additional values or ranges | Numbers, ranges of cells with numbers |
Examples of use
Calculating the average range
=AVERAGE(A1:A10)
Result: the average of the numbers in the range from A1 to A10.
Calculating the average of several ranges
=AVERAGE(A1:A10, B1:B10)
Result: the average of the numbers in ranges A1:A10 and B1:B10.
Calculating the average value for individual numbers
=AVERAGE(5, 15, 25)
Result: 15.
Notes
- The AVERAGE function ignores text values and empty cells in the range.
- If all arguments of the function are zero or missing, the function will return the #DIV/0! error.