Math & Trig
Aggregation
SUM Function
Adds all the numbers in a range of cells.
Step-by-Step Tutorial
- Select a cell where you want the result.
- Type =SUM(
- Select the range of cells you want to add.
- Close the parenthesis and press Enter.
Syntax
SUM(number1, [number2], ...)Interactive Demo
Watch the formula in action.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |