AVERAGEA Function

The AVERAGEA function is one of the statistical functions. It is used to analyze the range of data including text and logical values and find the average value. The AVERAGEA function treats text and FALSE as a value of 0 and TRUE as a value of 1.

Syntax

AVERAGEA(value1, [value2], ...)

The AVERAGEA function has the following arguments:

Argument	Description
value1/2/n	Up to 255 values for which you want to find the average value.

Notes

How to apply the AVERAGEA function.

Examples

The figure below displays the result returned by the AVERAGEA function.