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 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. |
Return Type and Value: number – The arithmetic mean of the values of its arguments.