This function calculates the average of the specified numeric values.
AVERAGE(value1,value2,...)
AVERAGE(array)
AVERAGE(array1,array2,...)
Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
This is a measure of the variability in a data set.
This function differs from AVERAGEA, which accepts text or logical values as well as numeric values.
Accepts numeric data for all arguments. Returns numeric data.
AVERAGE(A1,B3,D5,E9,L8,L9)
AVERAGE(R1C1,R3C2)
AVERAGE(A1:A9)
AVERAGE(A1:A9,B1:B9,D5:D8)
AVERAGE(98,72,85) gives the result 85