← Back to level 1
Level 1Level 1
SUM
Adds numbers together across a range or multiple ranges.
Syntax
=SUM(number1, number2, ...)Step-by-step explanation
- 1Select the cells or range that contain the numbers you want to total.
- 2Enter the formula in a result cell and press Enter.
- 3Excel returns the combined total instantly.
Common mistakes
Selecting the wrong range
Typing text instead of numeric cells
Forgetting hidden rows may affect totals
Example table
A quick scenario to connect the syntax to the result.
| 10 | 20 |
| 15 | 25 |
Formula
=SUM(A1:B2)
Result
70
Practice area
Total the sample revenue table with SUM.
Match against the syntax block above.