AVERAGEA Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

AVERAGEA is an Excel Statistical function. Averages values, treating text and FALSE as 0 and TRUE as 1.

AVERAGEA syntax

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

AVERAGEA is used in data analysis work to summarize or test patterns across a data set.

Open the live Excel-style spreadsheet and try AVERAGEA yourself. No Excel install or sign-up needed to start.

What does the AVERAGEA function do in Excel?

Averages values, treating text and FALSE as 0 and TRUE as 1.

What is the syntax of AVERAGEA in Excel?

The syntax is =AVERAGEA(value1, [value2], ...). value1: The first value; value2: An additional value (optional).

Where can I practice AVERAGEA online for free?

Open the free live spreadsheet on Cellgrids and try AVERAGEA yourself. No Excel install is needed and you can start without signing up.