AVERAGEA function

AVERAGEA(First, Other...) AVERAGEA(First; Other...)

First

Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color }

The first parameter.

Other

Number, Logical, Text, Color, { Number }, { Logical }, { Text } or { Color } (accepts many)

Additional parameters.

Returns

Number

The average of the parameters.

Returns the average (arithmetic mean) of the parameters. AVERAGEA(2, "6", 4)AVERAGEA(2; "6"; 4) returns 4.

AVERAGEA accepts numbers, logical values and text strings representing numbers. AVERAGE, by contrast, only accepts numbers. TRUE is interpreted as 1, FALSE is interpreted as 0, colors are ignored and text strings are parsed as though TONUMBER is used.

AVERAGEA takes the language of the app into account when converting text strings to numbers. When AVERAGEA is used with an app whose language is set to German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. When AVERAGEA is used with an app whose language is set to UK English, for instance, a decimal point (".") should be used. Thousands separators may not be used.

Use TRIMMEAN to discard a percentage of the smallest and largest elements of the array before calculating the average.

Examples

AVERAGEA(2, "6", 4)AVERAGEA(2; "6"; 4)

Returns 4, the average of the three parameters.

AVERAGEA(TRUE, TRUE, TRUE, 3)AVERAGEA(TRUE; TRUE; TRUE; 3)

Returns 1.5, the average of the four given values. TRUE is interpreted as 1.

AVERAGEA(2, "6", BLANK(), 4)AVERAGEA(2; "6"; BLANK(); 4)

Returns 4, the average of the three given numbers. Blank values are ignored.

AVERAGEA(2, { "6", BLANK() }, 4)AVERAGEA(2; { "6"; BLANK() }; 4)

Returns 4, the average of the three given numbers. Arrays mixed with regular numbers are supported. Blank values are ignored.