[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

AVERAGEA

Syntax:

AVERAGEA ( argument-list )

Description: Computes the arithmetic mean of the values of its arguments.

Arguments:

Name

Type

Description

argument-list

logical, number, 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. Arguments with value TRUE evaluate to 1; arguments with value FALSE evaluate to 0. An array or cell reference argument that contains text evaluates to 0.

If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.

 

[Note: The function AVERAGE3.17.7.18) does not 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:

AVERAGEA(10,E1), where E1 is an empty cell, results in 10, as E1 is ignored
AVERAGEA(10,E2), where E2 contains TRUE, results in 5.5
AVERAGEA(10,E3), where E3 contains FALSE, results in 5

end example]