Math & Trig
Modern
SUM
Adds all the numbers in a range or list.
Available in All versions
Syntax
SUM(number1, [number2])What it returns
The sum of the supplied numbers.
Arguments
| Argument | Required | Description |
|---|---|---|
number1 |
Yes | The first number or range to add. |
number2 |
No | Additional numbers or ranges to add (up to 255). |
Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
Result
100
SUM adds up all the numbers in the range (100).
=SUM(B2:B100)Important to know
Ignores text and empty cells; adds only numbers.
For conditional sums, use SUMIF or SUMIFS.