AVG(<List>)

 

Description

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

 

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

AVG(A1, B9, J32, F16) = 21.125

Where A1 = 12, B9 = 34.5, J32 = 22, F16 = 16.

 

AVG(A1, A12:H13, 111+32) = <SomeNumber>

Which shows that you can use numbers, ranges, and expressions all together as arguments for AVG.