Is there a quick way to see a total without a formula?

Yes. Select the cells and look at the status bar at the bottom of the window, which shows their sum, average and count without changing the sheet.

Can I total several columns at once?

Yes. Select the empty cells under all the columns and click AutoSum. Excel writes a separate SUM formula for each column.

Does SUM work in the free Excel for the web?

Yes. AutoSum is on the Home tab and SUM formulas work the same way as in the desktop app.

Why use SUM instead of adding cells with plus signs?

SUM ignores text instead of showing an error, and it adjusts when you insert or delete rows inside its range. A formula with plus signs does neither.

Microsoft Excel guide

How to add up a column in Excel

7 October 2026 · 2 min task · Tested

By Elias Brandt

Elias Brandt writes about marketing, email and analytics tools for Appcyclopedia, working on a ThinkPad X1 Carbon Gen 10 and a Galaxy S25.

Windows
macOS
Web

Short answer

Click the empty cell under the numbers, then AutoSum on the Home tab, and press Enter. Excel writes a formula such as =SUM(B2:B10) and shows the total. You can also type that formula yourself.

If a number is left out: SUM skips anything stored as text, so a figure that looks like a number but is aligned to the left of its cell is not in the total.

Below: AutoSum and the typed formula, totalling a row or several columns at once, and how to fix a total that looks wrong.

Total a column in Excel, two ways

To add up a column in Excel, let AutoSum write the formula or type it yourself. Both give the same SUM formula; AutoSum is faster, typing gives you exact control over which cells count.

With AutoSum

Click the empty cell under the numbers

Select the first empty cell directly below the column you want to total. For a row, select the empty cell immediately to its right. The total will appear in this cell.
Click AutoSum on the Home tab

On the Home tab, click AutoSum, the Σ button near the right. It is also on the Formulas tab. Excel writes a SUM formula and outlines the cells it plans to add with a moving border. On Windows, Alt+= does the same; on a Mac, Command+Shift+T.
Check the range and press Enter

Look at the moving border. If it covers every number, press Enter and the total appears. If it stops short, drag over the right cells before pressing Enter. The same steps work in Excel for the web.
By typing the formula

Type =SUM( and select the cells

Click the cell for the total and type =SUM(. Then drag over the numbers, or type the range, such as B2:B10, which means every cell from B2 to B10. Type ) and press Enter.
Add separate ranges with a comma

To add two blocks that are not next to each other, separate them with a comma: =SUM(B2:B10, D2:D10). A formula can hold up to 255 separate ranges or numbers.

A household budget is the usual first case: amounts in B2 to B13, one per month, and the year’s total in B14 with =SUM(B2:B13).

Put the total directly under the column with no empty row between, and AutoSum will guess the right range almost every time.

More about Microsoft Excel

Microsoft’s spreadsheet app, free on the web with a Microsoft account.

Read Microsoft Excel’s profile →

When the total is not what you expect

One or more numbers are missing from the total: They are stored as text. SUM ignores text, so the total is too low. Look for numbers aligned to the left or a small green triangle in the corner, select them, and choose Convert to Number.
The total did not grow after you added a row: You added the row outside the range, below the last cell in the formula. Insert new rows inside the range, above the total, and SUM includes them on its own.
A formula like =B2+B3+B4 shows #VALUE!: One of those cells holds text. Use =SUM(B2:B4) instead, which skips text and adds the numbers.
AutoSum picked the wrong cells: It stops at the first empty cell or text heading it meets. Drag over the correct range before pressing Enter, or edit the range in the formula bar afterwards.

What SUM counts, and what it skips

SUM adds every number in the range you give it. It quietly passes over anything else, which is useful until it hides a mistake.

Cell contains	Counted by SUM?
A number, such as 120	Yes
A formula that returns a number	Yes
A number stored as text, such as ‘120	No
A word or a heading	No
An empty cell	No
An error, such as #N/A	No: the whole SUM shows the error

Numbers stored as text are the usual cause of a total that is slightly too low. They often arrive that way when data is pasted from a website or exported from another program.

SUM or plus signs?

Adding cells one by one, as in =B2+B3+B4, works for three cells and goes wrong as a sheet grows.

Text in a cell: plus signs return #VALUE!; SUM skips the text.
Deleting a row: plus signs can turn into #REF!; SUM adjusts.
Inserting a row inside the range: plus signs leave it out; SUM includes it.

Use SUM for any total you will keep using; plus signs only suit a quick one-off.

Totalling a row, or a whole table

AutoSum works across rows as well as down columns. Select the empty cell to the right of a row of numbers and click AutoSum, and Excel totals the row.

For a table with several columns, select the empty row underneath all of them and click AutoSum once. Each column gets its own SUM formula. You can also copy one total across, and Excel shifts the range for each column.

The column has a total

AutoSum gets most totals right in two clicks. The few minutes it saves are lost only when a number stored as text slips through.

Use AutoSum, glance at the outlined range before pressing Enter, and check any figure that sits on the left of its cell.

SUM and AutoSum, quick answers

Is there a quick way to see a total without a formula?: Yes. Select the cells and look at the status bar at the bottom of the window, which shows their sum, average and count without changing the sheet.
Can I total several columns at once?: Yes. Select the empty cells under all the columns and click AutoSum. Excel writes a separate SUM formula for each column.
Does SUM work in the free Excel for the web?: Yes. AutoSum is on the Home tab and SUM formulas work the same way as in the desktop app.
Why use SUM instead of adding cells with plus signs?: SUM ignores text instead of showing an error, and it adjusts when you insert or delete rows inside its range. A formula with plus signs does neither.

Share this guide

Was this guide helpful?

Test log

Followed the steps? Tell us how it went on your device. Entries appear here after we check them.

Worked Every step, start to finish · Elias Brandt and Daniel Okonkwo Team 7 October 2026

I tested this

Steps performed and confirmed 7 October 2026 14 days ago

When you need this

To total a column of numbers such as expenses, hours or sales, use AutoSum or a SUM formula in Excel instead of adding them by hand or typing every cell.

Describes: Excel for Microsoft 365 on Windows and Mac · Excel for the web
Takes: Under a minute
Platforms: Windows · macOS · Web
Published: 7 October 2026
Facts checked: 7 October 2026

Steps repeated and verified by Elias Brandt and Daniel Okonkwo on 7 Oct 2026, 12:26 PM EDT