Calculates the arithmetic mean of the values in a data set.
Syntax:
AVG(list)
Returns the arithmetic mean (average) of the numeric values in the list.
list 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 blank elements and text cells do not upset the average.
Example:
AVG(A1:A4)
where the cell values are "Sales"
, 10.00
, 17.00
and 21.00
will return the number 16.00
.