[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 AVERAGEA (§3.17.7.18) does include cell reference arguments that refer to logical values or text representations of numbers. end note] |
Return Type and Value: number – The arithmetic mean of the values of its arguments.
[Example:
AVERAGE(1,2,3,4,5) results in 3
AVERAGE({1,2;3,4}) results in 2.5
AVERAGE({1,2,3,4,5},6,"7") results in 4
AVERAGE({1,"2",TRUE,4}) results in 2.5, as the logical value and numeric text are ignored
end example]