Formulas and Functions

AVERAGEA
The AVERAGEA function returns the average (arithmetic mean) of a collection of
values, including text and Boolean values.
AVERAGEA(value, value…)
 value: A value. value can contain any value type.
 value…:Optionally include one or more additional values. All numeric values must
be of the same type. You cannot mix numbers, dates, and duration values.
Usage Notes
A string value included in a referenced cell is given a value of 0. A Boolean FALSE is Â
assigned a value of 0 and a Boolean TRUE is assigned a value of 1.
A reference included as an argument to the function can be either to a single cell or Â
to a range of cells.
For a collection containing only numbers, AVERAGEA returns the same result as the Â
AVERAGE function, which ignores cells that don’t contain numbers.
Examples
=AVERAGEA(A1:A4) returns 2.5 if cells A1 through A4 contain 4, a, 6, b. The text values are counted
as zeros in the sum of 10 and included in the count of values (4). Compare with =AVERAGE(A1:A4),
which ignores the text values completely for a sum of 10, a count of 2, and an average of 5.
=AVERAGEA(A1:A4) returns 4 if cells A1 through A4 contain 5, a, TRUE, 10. The text value counts zero
and TRUE counts 1 for a sum of 16 and a count of 4.
=AVERAGEA(A1:A4) returns 0.25 if cells A1 through A4 contain FALSE, FALSE, FALSE, TRUE. Each FALSE
counts zero and TRUE counts 1 for a sum of 1 and a count of 4.
Related Topics
For related functions and additional information, see:
“AVERAGE” on page 231
“AVERAGEIF” on page 233
“AVERAGEIFS” on page 234
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
232 Chapter 10 Statistical Functions