How to Use SUM Formula






What Does It Do?
This function creates a total from a list of numbers.                                                                                                                        
It can be used either horizontally or vertically.                                                                                                                   
The numbers can be in single cells, ranges are from other functions.                                                                                                                      
                                                                                                                                               
Syntax
=SUM(Range1,Range2,Range3... through to Range30).                                                                                                                 
                                                                                                                               
Formatting
No special formatting is needed.                                                                                                                             
                                                                                                                                               
Note
Many people use the =SUM() function incorrectly.                                                                                                                         
This example shows how the SUM has been combined with plus + symbols.
The formula is actually doing more work than needed.                                                                                                                  
It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).

 



Popular Posts