The AVERAGE function calculates the unweighted average value of one or more values in a list. The formula used is:
SUM(list)/ n
where n is the number of values in the list. The list can include cell addresses, ranges, and cell names. This function can be abbreviated to AVG.
For example:
AVERAGE(10, 20, 30)
returns 20.
See also: