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