Author: Oscar Cronquist Article last updated on March 27, 2018

The AVERAGEA function returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1.

Formula in cell D3:

=AVERAGEA(B3:B7)

0 + 1 + 2 + 1 + 0 = 4/5 = 0.8

Excel Function Syntax

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

Arguments

value1 Required. Values for which you want to calculate the average.
[value2] Optional. Up to 254 additional arguments.

Comments

The AVERAGEA function evaluates 1 for boolean value TRUE and 0 (zero) for FALSE. Text values and formulas that return nothing "" evaluate to 0 (zero).

This table shows the difference between AVERAGEA and AVERAGE functions.

Values AVERAGEA AVERAGE
Text values 0 Ignored
Empty cells Ignored Ignored
TRUE 1 Ignored
FALSE 0 Ignored