AVERAGE(list) or AVG(list)

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:

Other statistical functions