Related Topics: | ||
Description: Returns the average (arithmetic mean) of the arguments.
Syntax: AVERAGE(Number1, Number2,...)
Number1, Number2, ... are 1 to 30 numerical arguments for which you want the average.
Remarks:
The arguments must either be numbers or be names, arrays, or cell 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.
Example:
AVERAGE(10, 7, 9, 27, 2) = 11
AVERAGE(A1:A6) returns an average of the values in the cells A1 through A6.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.