Wauvel

Excel like a finance pro.

← The library

Statistical function

AVERAGEA

Returns the mean counting text as 0 and TRUE as 1.

Rarely usedDifficulty 1100 · ProficientUsage rank #148 of 520
Practice · 2 questions →

When to use it

AVERAGE that counts text as 0 and logical values as 1 or 0. Use it when a text entry like "n/a" should drag the average down instead of being ignored.

The shape of it

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

Worked examples

  • Text counts as zero

    =AVERAGEA(10,20,"text") → 10

    The text counts as 0: 30 divided by 3.

  • Logicals

    =AVERAGEA(TRUE,FALSE) → 0.5

    TRUE is 1 and FALSE is 0.

  • A range with a text placeholder

    =AVERAGEA(A2:A4) → 10

    A2:A4 holds 10, 20, and "n/a".

Worth knowing

  • Survey scores where "no answer" should count as 0 are the classic case.
  • Blanks are still ignored; only text and logicals are counted.
  • If text should be skipped, use AVERAGE.

Where it goes wrong

  • Text in the range silently pulls the mean toward zero.
  • Numbers stored as text count as 0, not as their value.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.