AVERAGE

Averages the given expressions (adds up all the expressions and divides the outcome by the number of expressions added).  If an expression evaluates to a range of cells all the values in the range are averaged. Text  in ranges are ignored.  If an error condition is encountered in a range of cells, the average function errors as well.

Syntax

AVERAGE(expression,{expression},...)

Arguments

expression - numbers or references to average.

Examples

AVERAGE(3.14,-2,2) = 1.047

AVERAGE(A2..B5,200)