Google Sheets function
SUM function in Google Sheets
SUM in Google Sheets adds numbers, cell values, and ranges into one total. Give it one required value or range, then add more optional values or ranges separated by commas. Text inside referenced ranges is ignored, making SUM useful for totals such as expenses, hours, or quantities.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=SUM(value1, [value2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
value1 | Yes | The first number or range to add. |
value2, ... | No | Additional numbers or ranges to add to the total. |
Examples
Add a range of costs
| A | B | |
|---|---|---|
| 1 | Item | Cost |
| 2 | Rent | 1200 |
| 3 | Food | 340 |
| 4 | Phone | 45 |
=SUM(B2:B4)Result: 1585
SUM adds every numeric value from B2 through B4.
Common mistakes
Using commas between the first and last cell when you mean the whole range.
Use a colon for a continuous range, such as B2:B4.
Typing the total as a fixed number.
Use SUM so the result changes when the source cells change.