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.