Get the average of a group of numbers

A number representing the average.

=AVERAGE (number1, [number2], ...)

**number1**- A number or cell reference that refers to numeric values.**number2**- [optional] A number or cell reference that refers to numeric values.

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.*