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 | |||||||||