| 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 |
|
|
| ||
Saturday, January 22, 2011
Simple Sum Formula
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment