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:

Return Type and Value: number – The arithmetic mean of the values of its arguments.