Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > AVERAGE
 

AVERAGE(number1, number2 [,number3] [,…])

 
 Returns the arithmetic mean for a list of numbers.

 number1The first number.
 number2The second number.
 number3The third optional number.

 REMARKS
 
  		• The arithmetic mean is the total of all the values divided by the number of values.
     
  		• The arguments can be values, cell references, arrays or named ranges.
     
  		• If any arguments evaluate to True, then 1 is used.
     
  		• If any arguments evaluate to False, then 0 is used.
     
  		• If any arguments contain text, then #VALUE! is returned.
     
  		• If any arguments are zero then these are counted.
     
  		• If any cell references contain an error then that error is returned (Row 15).
     
  		• If any cells are empty, then these are not counted, although any cells that contain a zero are counted. Check your (Tools > Options)(View tab, "Zero values").
     
  		• You can enter the abbreviated function name "AVG" although you will be prompted to change this to "AVERAGE".
     
  		• You can have a maximum of 30 arguments.
     
  		• If you do not want to count any arguments that are text or logical values you can use the AVERAGEA() function.
     
  		• AVERAGEIF() - Returns the average of a range of values that match a certain condition.

     EXAMPLES
     
     AB
    1=AVERAGE(2,4) = 35
    2=AVERAGE(5,10,15) = 1010
    3=AVERAGE(5,10,15,0) = 815
    4=AVERAGE(2,3,4,5,6) = 4 
    5=AVERAGE({2,3,4,5,6}) = 40
    6=AVERAGE(B1:B3) = 10text
    7=AVERAGE(B1,B2,B3) = 10FALSE
    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! 
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top