Matheasy
SUM()
Returns the sum of a series of numbers and/or cells.
Syntax
fx
=SUM(value1, [value2, ...])
Try it
F2
→
399,000
Sample data · sales.csv
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Company | Region | Quarter | Revenue |
| 2 | Acme Co | West | Q1 | 18,400 |
| 3 | Acme Co | West | Q2 | 22,100 |
| 4 | Acme Co | West | Q3 | 31,700 |
| 5 | Acme Co | West | Q4 | 48,200 |
| 6 | Globex | East | Q1 | 14,200 |
| 7 | Globex | East | Q2 | 19,800 |
| 8 | Globex | East | Q3 | 23,400 |
Common pitfalls
SUMignores text cells silently. If you expect a number and a stray text value sneaks in, you won't get an error: debug withSUMPRODUCT(--ISNUMBER(range))to count numerics.- Whole-column refs (
SUM(A:A)) work but pull every row of the spreadsheet, which slows recalc on big sheets. Prefer explicit ranges. SUM(A1:A10) + B1is fine butSUM(A1:A10, B1)is more idiomatic and reads cleaner.
Related formulas