# AVERAGE

Returns the average (arithmetic mean) of the arguments.

**Syntax**

**AVERAGE**(**number1**,number2, ...)

**Number1**, number2, ... are 1 to 30 numeric arguments for which you want the average.

**Remarks**

- The arguments must be either numbers or names, arrays, or references that contain numbers.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

**Tip** When averaging cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the **Zero values** check box on the **View** tab (**Options** command, **Tools** menu). Empty cells are not counted, but zero values are.

**Examples**

If A1:A5 is named Scores and contains the numbers 10, 7, 9, 27, and 2, then:

`AVERAGE(A1:A5)`

equals 11

`AVERAGE(Scores)`

equals 11

`AVERAGE(A1:A5, 5)`

equals 10

`AVERAGE(A1:A5)`

equals `SUM(A1:A5)/COUNT(A1:A5)`

equals 11

If C1:C3 is named OtherScores and contains the numbers 4, 18, and 7, then:

`AVERAGE(Scores, OtherScores)`

equals 10.5