### 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 rows.* 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 if you want to exclude hidden rows.* You can use the AGGREGATE function to exclude hidden rows.* 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 page under Quant > Central Tendency > Mean.* 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.office.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.