SUM
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.
| 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)) | |
Example:
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 | |||