Syntax:
AVG(list)
Returns the arithmetic mean value of the numeric values in the list, which may be an array, a range of cells, or a comma-separated list of values.
Note that only numeric values are included in the calculation, so that text and blank cells do not upset the average.
Example:
AVG(A1:A4)
where the cell values are "Sales"
, 10.00
, 15.00
and 20.00
will return the number 15.00
.