Excel functions / Statistics

AVERAGEA function

The average, counting text in a range as 0 and TRUE as 1.

Syntax

=AVERAGEA(value1, [value2], …)

Arguments

When to use it

AVERAGEA averages a range counting text and FALSE as 0 and TRUE as 1, where AVERAGE skips them. It suits a column where "absent" or "no" really means zero.

Examples

  1. Absent counts as zero

    ABC
    1Score
    28050
    3absent
    470

    In C2: =AVERAGEA(A2:A4) → 50

    Try this example

  2. The share of TRUE answers

    ABC
    1Attended
    2TRUE75%
    3FALSE
    4TRUE
    5TRUE

    In C2: =AVERAGEA(A2:A5) → 75%

    Try this example

Common mistakes

AVERAGEA in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try AVERAGEA in the playground

Related functions