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:

**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

Grey Trout Software

02 March 2003