The SUM function
Adds numbers, cell references and ranges. Text and blank cells in a range are ignored.
Syntax
SUM(number1, [number2], ...)- number1
- The first number, cell or range to add.
- number2 (optional)
- More numbers or ranges, up to 255 in all.
Examples
E1=SUM(C2:C6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 1650 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
E1
=SUM(1C2:C3,2C5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 1220 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
In plain words: Add up 1the sales in C2:C3 and 2the sales in C5.
Practice SUM
Read the guide
Questions
What is the shortcut for SUM in Excel?
Alt+= (Cmd+Shift+T on a Mac) inserts AutoSum, which writes =SUM() around the numbers above or to the left.