Skip to main content

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:

ArgumentDescription
value1/2/nUp 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.

AVERAGEA Function