** Syntax**. AVERAGE(

** Definition**. This function returns the average (arithmetic mean) of the arguments. To calculate the average, the interval-scaled variables are added and then divided by their number.

**Arguments**

. At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the average*number1*(required) and*number2*(optional)

Arguments can be numbers, names, arrays, or references containing numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value 0 are included.

** Background**. The arithmetic mean is the best known mean value and is widely accepted among nonstatisticians. Because the mean ...

Start Free Trial

No credit card required