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