Quick Navigation

AVERAGEA Function

Excel 2007+

Summary

The AVERAGEA function calculates the arithmetic mean of a dataset, uniquely including logical values (TRUE/FALSE) and text representations of numbers in the calculation. Unlike standard AVERAGE, it treats TRUE as 1, FALSE as 0, and numeric text as its value, providing more comprehensive averaging across mixed data types.

Syntax

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

Parameters

Parameter	Type	Required	Description
value1	`Any`	Yes	Required. First number, cell reference, range, or array to average
value2	`Any`	No	Optional. Additional numbers, cell references, ranges, or arrays (up to 255 total arguments)

Using the AVERAGEA Function

AVERAGEA excels when working with datasets containing logical flags, status indicators, or imported data with text numbers. Use it for survey responses (Yes/No), checkboxes, or any scenario where TRUE/FALSE values carry numeric meaning in your average calculation.

Common AVERAGEA Examples

Basic Mixed Data Average

=AVERAGEA(A1:A5)

A1=10, A2=7, A3=TRUE, A4="9", A5="Not a number". Returns 6.75 (10+7+1+9+0)/5.

Range with Text and Logical

=AVERAGEA(B1:B6)

B1=10, B2="Not available", B3=TRUE, B4=3, B5=FALSE, B6=8. Returns 4.67.

Multiple Arguments

=AVERAGEA(5, TRUE, "10", FALSE, A1)

Combines constants, logicals, text numbers, and references.

Frequently Asked Questions

Text like "123" or "45.6" converts to numbers and gets included in the average.

TRUE counts as 1, FALSE counts as 0. Direct arguments and references both work.

AVERAGE ignores logicals and text in references; AVERAGEA includes them.

Common Errors and Solutions

#DIV/0!

Cause: All arguments are text strings, logicals, or errors

Solution: Include at least one numeric value

#VALUE!

Cause: Array argument contains incompatible data

Solution: Ensure ranges contain averageable data

Notes

Empty cells (blank) are ignored
Zero-formatted cells (displaying as blank) count as 0
Error values in ranges propagate to the result
Text strings that aren't numbers evaluate as 0
Maximum 255 arguments total

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+