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

AVERAGEA(value1, value2 [,value3] [,…])

 
 Returns the arithmetic mean of a list or array of numbers.

 value1The first value.
 value2The second value.
 value3The third optional value.

 REMARKS
 
  		• This is identical to the AVERAGE() function except that text and logical values are included.
     
  		• The only difference can be seen in row 10. Here the text entry is included.
     
  		• The arithmetic mean is the total of all the values divided by the number of values.
     
  		• Empty text ("") evaluates as 0.
     
  		• 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 text then these are not counted.
     
  		• If any cell references contain an error then an error is returned.
     
  		• Any empty cells are not counted, although zero values are. Check your (Tools > Options)(View tab, "Zero values").
     
  		• You can have a maximum of 30 arguments.
     
  		• AVERAGEIF() - Returns the average of a range of values that match a certain condition.

     EXAMPLES
     
     AB
    1=AVERAGEA(2,4) = 35
    2=AVERAGEA(5,10,15) = 1010
    3=AVERAGEA(5,10,15,0) = 815
    4=AVERAGEA(2,3,4,5,6) = 4 
    5=AVERAGEA({2,3,4,5,6}) = 40
    6=AVERAGEA(B1:B3) = 10text
    7=AVERAGEA(B1,B2,B3) = 10FALSE
    8=AVERAGEA(B1,B2,B3,B4) = 10=10/0 = #DIV/0!
    9=AVERAGEA(B1,B2,B3,B6) = 8 
    10=AVERAGEA(B1,B2,B3,B5) = 8 
    11=AVERAGEA(1,2,3) = 2 
    12=AVERAGEA(1,2,3,TRUE) = 1.8 
    13=AVERAGEA(1,2,3,FALSE) = 1.5 
    14=AVERAGEA(named_range) = 10 
    15=AVERAGEA(B5,B6,B8) = #DIV/0! 
    16=AVERAGEA(2,"some text") = #VALUE! 
    		 
     Functions - A | Index - A | Office Online 

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