.

SUM Function Dictionary

Function Dictionary Function Examples Function Categories

SUM            
 
 
Horizontal
100 200 300 600  =SUM(C4:E4)
Vertical
100
200
300
600  =SUM(C7:C9)
Single Cells    
100 300 600  =SUM(C13,D14,E13)
200
Multiple Ranges    
100 400
200 500
3000 600
4800  =SUM(C17:C19,E17:E19)
Functions    
100 400
200 500
300 600
800  =SUM(AVERAGE(C23:C25),MAX(E23:E25))
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).
100
200
300
600  =SUM(C48+C49+C50) Wrong!
 =SUM(C48:C50) Correct
 =C48+C49+C50 Correct

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download