AVERAGE
Syntax:
AVERAGE ( argument-list )
Description: Computes the arithmetic mean of the numeric values of its arguments.
Arguments:
Name |
Type |
Description |
---|---|---|
argument-list |
logical, number, name, text, or reference that contains a number. |
The arguments in argument-list designate the values to be averaged. An argument that is a logical value or the text representation of a number shall be counted. If an array or cell reference argument contains logical values, text, or empty cells, those values shall be ignored; however, cells having the value 0value 0 shall be counted.
Note: : The function
3.17.7.18) does include cell reference arguments that refer to logical values or text representations of numbers. ]AVERAGEA (§ |
Return Type and Value: number – The arithmetic mean of the values of its arguments.
example: