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 references that contain numbers.
If an array or column reference argument contains text, logical values, or is empty, those values are either ignored or return the #VALUE! error value; however, arguments with the value zero are included.

Example

Col1	Col2	Col3	Col4	Col5	Formula	Description (Result)
10	7	9	27	2	=AVERAGE([Col1], [Col2], [Col3], [Col4], [Col5])	Average of the column numbers (11)
10	7	9	27	2	=AVERAGE([Col1], [Col2], [Col3], [Col4], [Col5], 5)	Average of the column numbers and 5 (10)