AVERAGEA FUNCTION

The AVERAGEA function returns the average of a set of data. The AVERAGEA function differs from the AVERAGE function in the fact that it uses text and logical results as a part of its calculation of the average. The AVERAGEA function can be broken down into three categories:

Data Set

TRUE

FALSE

TRUE

FALSE

TRUE

·         There can be a maximum of 255 values in a set of data.

·         AVERAGEA with calculate the average the same exact way as AVERAGE if the data set only contains numbers.

·         A value of TRUE in a cell returns a value of one for the calculation purposes of this function.

·         A Value of False or any text-based values will return a value of zero for the calculation purposes of this function.

Sum of Data Set

1+0+1+0+1

=   3

Average

Sum of Data set		3	=    0.6
Number of Data Points		5

So what does this show? Well if you had a test with five true or false questions, the AVERAGEA function will show the percent of true answers on the test. In the example above the average was 0.6, when multiplied by 100 you get 60% of the test was true.