AVERAGE
Name
Average
Description
Returns the average of the specified values.
Syntax
AVERAGE(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell range, a float value, or an integer value.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
AVERAGE(A1,B3,D5,E9)
AVERAGE(R1C2,R3C1)
AVERAGE(A1:A9)
AVERAGE(98,72,85)=85