Returns the average of the arguments, ignoring text.
AVERAGE(number1, number2, ... number30)
number1 to number30 are up to 30 numbers or ranges containing numbers.
AVERAGE(2, 6, 4)
returns 4, the average of the three numbers in the list.
where cells B1, B2, B3 contain 1, 3, and apple returns 2, the average of 1 and 3. Text is ignored.