SUM
Adds numbers together.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Number
Examples
=SUM(1,2,3) Result 6
=SUM(A1:A10) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
Result 150
=SUM(A1, B1, C1:C10) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | beta | ||
| 3 | gamma | ||
| 4 | delta | ||
| 5 | epsilon |
Result 12
Syntax
SUM(number…)number…- number required
Errors
#REF!=SUM(Sheet2!A1:C3)*Sheet3!A2