AVERAGEA

AVERAGEA - This function returns the average of a sample. The value of a text is zero.

Syntax:

AVERAGEA(number1;number2; ...)

number1, number2, ... are numerical values or ranges.

Example:

Suppose we have given a test and we want to know the class average. One student did not take the test and you put a not on your grade sheet. However, you want to count this score as a zero. Refer to the screen shot.

=AVERAGEA(B2:B7) will return 62

Screen shot: