Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Maths and Trigonometry > SUM
 

SUM(number1, number2 [,number3] [,...])

 
 Returns the sum of a list of numbers.

 number1The first number.
 number2The second number.
 number3(Optional) The third optional number.

 REMARKS
 
  		• This function includes hidden rows.
     
  		• The number arguments can be values, cell references, named ranges or even other functions.
     
  		• Empty cells, logical values, text, or error values in the array or reference are ignored.
     
  		• If an argument is a cell reference, only numbers are counted.
     
  		• Numbers can also be logical values as well as text.
     
  		• If an argument is an array then #VALUE! is returned.
     
  		• You can include non-continuous cell ranges but separating them with a comma.
     
  		• There is also an AutoSum button located on the standard toolbar to help you enter this function quickly.
     
  		• It is possible to add up all the values in a particular column. To sum all the values in column "C" use: "=SUM(C:C)".
     
  		• You can have a maximum of 30 arguments.
     
  		• Example 1 -
     
  		• Example 2 -
     
  		• Example 3 -
     
  		• Example 4 -
     
  		• Example 5 -
     
  		• Example 6 -
     
  		• Example 7 -
     
  		• Example 8 -
     
  		• Example 9 -
     
  		• Example 10 -
     
  		• Example 11 -
     
  		• Example 12 -
     
  		• Example 13 -
     
  		• Example 14 -
     
  		• Example 15 - Array Formula.
     
  		• Example 16 -
     
  		• Example 17 - Array Formula. What is the sum of the squares of the numbers {1,2,3,4}.
     
  		• Example 18 -
     
  		• Example 19 -
     
  		• Example 20 -

     EXAMPLES
     
     AB
    1=SUM(3,2) = 53
    2=SUM(B1,B2) = 52
    3=SUM(B1:B2) = 53
    4=SUM(B1,B2,B3) = 8some text
    5=SUM(B1,B2,B3,B5) = 8 
    6=SUM("3","2",B3) = 8some
    7=SUM(B1:B5,"0") = 8text
    8=SUM(B1:B3,15) = 23 
    9=SUM(LEN(B1),LEN(B4)) = 10 
    10=SUM(10,20,30) = 60 
    11=SUM({10,20,30}) = 60 
    12=SUM(1/COUNTIF(B1:B3,"<10")) = 0.33 
    13=SUM(IF(B1:B3>=20,IF(B1:B3<=100,B1:B3,0),0)) = 0 
    14=SUM(IF(B1:B3>=20,IF(B1:B3<=100,1,0),0)) = 0 
    15{=SUM(LEN(B6:B7))} = 8 
    16=SUM(LEN("some text")) = 9 
    17{=SUM({1,2,3,4}^2)} = 30 
    18=SUM(1,2,"some text") = #VALUE! 
    19=SUM(B1:B5,"") = #VALUE! 
    20=SUM(LEN(B6:B7)) = #VALUE! 
    		 
     Functions - S | Index - S | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top