AVERAGE

AVERAGE(number1 [,number2] [..])

Returns the arithmetic mean of non blank cells in a list, table or cell range.

number1	The first number.
number2	(Optional) The second number.

REMARKS

* The arithmetic mean is the most common measure of central tendency.
* This function includes hidden cells.
* Arguments that are numbers are included.
* Arguments that are zero are included.
* Arguments that are dates are included.
* Arguments that are logical values are excluded from the denominator.
* Arguments that are text are excluded from the denominator.
* If any cell references are empty, then these are excluded.
* If any cell references contain an error, then that error is returned (Row 15).
* You can have a maximum of 255 arguments.
* You can use the AVERAGEA function to include logical values and text in the denominator.
* You can use the AVERAGEIFS function to satisfy multiple conditions.
* You can use the AVERAGEVISIBLE - User Defined Function to exclude hidden cells.
* You can use the AGGREGATE function to exclude hidden cells.
* This is similar to the COUNT function.
* This is similar to the MAX function.
* This is similar to the MIN function.
* This is similar to the SUM function.
* For an illustrated example refer to the Quant > Central Tendency > Mean page.
* You can enter the abbreviated function name "=AVG()" although you will be prompted to change this to "AVERAGE".
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=AVERAGE(2,4) = 3	5
2	=AVERAGE(5,10,15) = 10	10
3	=AVERAGE(5,10,15,0) = 8	15
4	=AVERAGE(2,3,4,5,6) = 4
5	=AVERAGE({2,3,4,5,6}) = 4	0
6	=AVERAGE(B1:B3) = 10	text
7	=AVERAGE(B1,B2,B3) = 10	FALSE
8	=AVERAGE(B1,B2,B3,B4) = 10	=10/0 = #DIV/0!
9	=AVERAGE(B1,B2,B3,B6) = 10
10	=AVERAGE(B1,B2,B3,B5) = 8
11	=AVERAGE(1,2,3) = 2
12	=AVERAGE(1,2,3,TRUE) = 1.8
13	=AVERAGE(1,2,3,FALSE) = 1.5
14	=AVERAGE(named_range) = 10
15	=AVERAGE(B5,B6,B8) = #DIV/0!
16	=AVERAGE(2,"some text") = #VALUE!

1 - What is the arithmetic mean or average of 2 and 4.
2 - What is the arithmetic mean or average of 5, 10 and 15.
3 - What is the arithmetic mean or average of 5, 10, 15 and 0. Zeros are included.