AVG, AVERAGE

Syntax:	AVG(argumentlist)
	AVERAGE(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

AVG returns the average (arithmetic mean) of its arguments. Blank cells and strings are ignored. The function is given by:

$$\left( \sum_{i=1}^N a_i \right)/N$$

AVERAGE is a synonym for AVG.

Examples:

AVG(A1, B9, J32, F16) = 21.125, where A1 = 12, B9 = 34.5, J32 = 22, F16 = 16

AVG(A1, A12..H13, 111+32) = 135.67, where we don't really care what is at those variables, but which shows that you can use numbers, ranges, and expressions all together as arguments for AVG.

Excel function: AVERAGE