# SUM function in Excel

> SUM adds numbers.

Source: https://spreadsheetpractice.com/functions/sum · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** SUM adds numbers.
- **Syntax:** `=SUM(number1, [number2], ...)`
- **Most common use:** `=SUM(B2:D2)` returns $2,175 (Adds across a row: everything spent in January)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The total of every number in the arguments.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

SUM adds numbers. Give it a range, several ranges, single cells or typed numbers, and it returns the total. It skips text and empty cells inside ranges, which is why a header row or a blank line in the middle of your data doesn't break it.

## Syntax

`=SUM(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range to add, such as B2:B13. |
| `number2` | Optional | More numbers, cells or ranges to add. You can list up to 255. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=SUM(B2:D2)` | $2,175 | Adds across a row: everything spent in January |
| B5 | `=SUM(B2:B4)` | $5,400 | Adds down a column: rent for the quarter |
| E5 | `=SUM(B2:D4)` | $6,500 | A block of rows and columns in one range: the quarter's total |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Month | Rent | Utilities | Supplies | Month total |
| 2 | Jan | $1,800 | $240 | $135 | $2,175 |
| 3 | Feb | $1,800 | $265 | $90 |  |
| 4 | Mar | $1,800 | $210 | $160 |  |
| 5 |  | $5,400 |  |  | $6,500 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Total is 0 or too low | Some numbers are stored as text, often after an import (they sit on the left of the cell). SUM skips them. Convert them with VALUE, or select the column and use Data > Text to Columns > Finish. |
| New rows are left out of the total | Rows added below the range aren't included. Insert new rows inside the range, or turn the data into a table (Ctrl+T) so the range grows on its own. |
| Circular reference warning | The range includes the cell holding the formula, such as =SUM(B2:B5) typed in B5. End the range one row above the total. |
| #N/A or #DIV/0! in the total | SUM passes along any error inside its range. Fix the cell that has the error, or wrap the formulas that feed it in IFERROR. |

## Tips

- On Windows, select the cell under a column and press Alt+= to insert a SUM of the numbers above it.
- SUM ignores text, so =SUM(B:B) totals a whole column even with a header in B1. Just keep the formula itself out of column B.

## Related functions

- [SUMIF](https://spreadsheetpractice.com/functions/sumif): SUMIF adds up values for the rows that meet one condition: total travel expenses, revenue for one product, every invoice over $500.
- [SUMIFS](https://spreadsheetpractice.com/functions/sumifs): SUMIFS adds the values where every condition is true: East region widget sales, February revenue, large orders from one customer.
- [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct): SUMPRODUCT multiplies matching items in two or more ranges and adds the results.

## Questions

### How do I add up a column in Excel?

Type =SUM( then select the cells, close the bracket and press Enter, for example =SUM(B2:B50). Alt+= on Windows writes the formula for you.

### Why does my SUM formula return 0?

The numbers are almost always stored as text. Check whether they're left-aligned or show a small green triangle, then convert them to numbers.

### How do I add only the rows that match a condition?

Use SUMIF for one condition or SUMIFS for several, for example =SUMIFS(D2:D50, B2:B50, "East").

## Practice

A graded SUM exercise ("Weekly total") is on [the SUM page](https://spreadsheetpractice.com/functions/sum). It is checked instantly, then re-checked on changed data.

Lessons that use SUM:

- [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)
- [Lesson 27: FILTER](https://spreadsheetpractice.com/learn/filter-function) (Pro)
- [Lesson 31: LAMBDA with BYROW, MAP & SCAN](https://spreadsheetpractice.com/learn/lambda-byrow-map-scan) (Pro)
- [Lesson 35: SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
