Purpose
Get the average of a group of numbers
Return value
A number representing the average.
Syntax
=AVERAGE (number1, [number2], …)
Arguments
- number1 – A number or cell reference that refers to numeric values.
- number2 – [optional] A number or cell reference that refers to numeric values.
Usage notes
The AVERAGE function returns the average (arithmetic mean) of a group of supplied numbers. To calculate the average, Excel adds the numbers together and divides by the total number of numbers. For example, AVERAGE (2,4,6) returns 4.
Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied.
Note: the AVERAGE function will automatically ignore empty cells.
