AVERAGEA Function
Averages values, counting text as 0 and TRUE as 1.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
AVERAGEA works like AVERAGE, but in a range it also counts text (as 0), TRUE (as 1) and FALSE (as 0). Only truly empty cells are skipped.
That makes it handy for TRUE/FALSE columns — the average is the share of TRUEs.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range. |
| value2, … | No | Up to 255 more values, cells or ranges. |
Examples
Example 1 — Share of tasks done
Column B holds TRUE when the onboarding task is complete.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Task | Done | Share done | |
| 2 | Laptop set up | TRUE | 0.6 | |
| 3 | Email access | TRUE | ||
| 4 | Payroll form | FALSE | ||
| 5 | Safety video | TRUE | ||
| 6 | Team lunch | FALSE |
Format D2 as a percentage to show 60%.
Example 2 — Text counts as zero
The same scores as on the AVERAGE page: "absent" and "pending" now count as 0. The blank (Di) is still skipped.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Score | Average | |
| 2 | Ana | 82 | 41.67 | |
| 3 | Ben | absent | ||
| 4 | Cy | 91 | ||
| 5 | Di | |||
| 6 | Ed | 77 | ||
| 7 | Fay | 0 | ||
| 8 | Gus | pending |
250 ÷ 6 = 41.67, compared with 62.5 from AVERAGE.
Common mistakes
- Unexpectedly low results. Labels like "n/a" inside the range drag the average towards zero. Use AVERAGE if text should be ignored.
Notes
- Typed directly as arguments, text that looks like a number ("5") counts as that number, and other text gives #VALUE!.
- Related functions: AVERAGE, MAXA, MINA, COUNTA.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.