Excel: AverageA Function

In Excel, the AverageA function returns the average (arithmetic mean) of the numbers provided. The AverageA function is different from the Average function in that it treats TRUE as a value of 1 and FALSE as a value of 0.

The syntax for the AverageA function is:

AverageA( number1, number2, ... number_n )

number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=AverageA(B2, B3) would return 8.85

=AverageA(B3, B5, 45) would return 17.73333333

=AverageA(B2:B6) would return 43.74

=AverageA(B5, B6) would return 0.5