How to Add a Column and Sum It Up in Excel

The fastest way to add a column of numbers

Select the empty cell where you want the total to appear. Type =SUM( then click the first number in the column you want to add, hold Shift, and click the last number. Type ) and press Enter. Excel will add all the numbers between those two cells and show the result.

That formula works whether your column has 5 numbers or 500. If you add more numbers to that column later, you can click the cell with the formula and drag the small square at its bottom-right corner down to include the new numbers — Excel will adjust the formula automatically.

Key Takeaways

The SUM formula adds a range of cells: type =SUM( then select from the first number to the last, then close with ) and press Enter.
You can click and drag the formula down to explore it to multiple rows at once, and Excel will adjust the cell references for each row.
If you need to add only some cells in a column — skipping blank rows or specific entries — use SUMIF or list each cell individually with plus signs.
The formula bar at the top shows exactly what formula is in any cell, so you can check your work or edit it without retyping.

Selecting the exact range you want to sum

When you type =SUM( and then click a cell, Excel highlights that cell in blue. When you hold Shift and click another cell, Excel highlights the entire range between them in blue and shows you the cell addresses in the formula — for example, =SUM(A1:A10). This visual feedback prevents mistakes because you can see exactly which cells you are including before you press Enter.

If your column has a header row (like "Sales" or "Expenses"), start your selection from the first number below the header, not from the header itself. Excel will try to add text if you include it, which causes an error. The same applies if there are blank rows in the middle of your data — SUM skips blank cells automatically, but it will include any row with a number, even if that number is zero.

Copying the formula down to multiple rows

Once you have entered a SUM formula in one cell, you can copy it down to calculate totals for multiple columns or sections. Click the cell with the formula, then look for the small square at the bottom-right corner of the cell (called the fill handle). Click and drag that square down as far as you need, and Excel will copy the formula to each row below, automatically adjusting the cell references.

For example, if you have =SUM(A1:A10) in cell A11 and you drag down to A12, Excel changes it to =SUM(A2:A11). This is useful when you have multiple columns of data and want to total each one without retyping the formula. You can also select the cell with the formula and the cells below it, then use Ctrl+D (or Cmd+D on Mac) to fill down, which does the same thing.

When to use SUMIF instead of SUM

The SUM formula adds every number in a range. If you need to add only numbers that meet a certain condition — for example, only sales over $100, or only entries from a specific month — use SUMIF instead. The formula is =SUMIF(range, criteria, sum_range). The range is where Excel looks for the condition, the criteria is what you are looking for, and the sum_range is the numbers to add.

An example: if column A contains product names and column B contains sales amounts, and you want to total sales only for "Widget", you would type =SUMIF(A:A,"Widget",B:B). Excel will search all of column A for "Widget" and add only the corresponding numbers from column B. This saves time when you have a large spreadsheet and need to total only a subset of the data.

Adding cells that are not next to each other

If the numbers you want to add are scattered across the spreadsheet — not in one continuous column — you can list them individually in the SUM formula. Type =SUM( then click the first cell, type a comma, click the next cell, type another comma, and continue until you have listed all the cells you need. Then type ) and press Enter.

For example, =SUM(A5,A10,A15,C3) will add only those four specific cells, skipping everything in between. You can also combine ranges and individual cells: =SUM(A1:A10,C5,D1:D20) will add the range A1 through A10, plus cell C5, plus the range D1 through D20. This approach is slower than selecting a continuous range, but it is the only way to add cells that are not adjacent to each other.

Checking and editing your formula

Click any cell that contains a formula, and the formula bar at the top of the screen shows exactly what the formula says. This is useful for checking your work — you can see at a glance whether you included the right range. If you need to change the formula, you can click in the formula bar and edit it directly, or double-click the cell itself to edit it in place.

When you double-click a cell with a formula, Excel highlights the ranges in color so you can see which cells are being added. If the range is wrong, you can click and drag the colored border to expand or shrink it. This visual method is often faster than retyping the formula, especially if you need to adjust only the starting or ending cell.

Common mistakes and how to avoid them

The most common error is including text or headers in the range. If you see a #VALUE! error, check whether your range includes any cells with words instead of numbers. Another frequent mistake is forgetting the closing parenthesis — Excel will show an error if you type =SUM(A1:A10 without the ). The formula bar makes this straightforward to spot because the parenthesis will be missing.

A third mistake is selecting the wrong range by accident. If your total seems too high or too low, click the cell and look at the formula bar to see which range it is actually summing. You can also click the cell and look at the colored outline Excel draws around the range — if it does not match what you intended, edit the formula to fix it. Taking two seconds to verify the range before pressing Enter prevents most problems.

Frequently Asked Questions

Can I sum a column if the numbers are formatted as text?

No, SUM ignores cells that contain numbers formatted as text. If your total is lower than expected, the numbers may be stored as text rather than as actual numbers. You can fix this by selecting the cells, going to the Data menu, and using Text to Columns to convert them. After conversion, the SUM formula will include them.

What if I want to add only numbers above or below a certain value?

Use SUMIF with a criteria like ">100" or "<50". For example, =SUMIF(A:A,">100") adds all numbers in column A that are greater than 100. You can also use SUMIFS if you need to meet multiple conditions at once, such as adding sales over $100 only from January.

How do I sum a column if there are blank rows in the middle?

SUM automatically skips blank cells, so blank rows in the middle of your data do not affect the total. Just select from the first number to the last number in the column, and Excel will add only the cells with numbers, ignoring the empty ones.

Can I see the sum without creating a formula?

Yes. Select the cells you want to add, and look at the bottom-right corner of the Excel window — the status bar shows the sum, average, and count automatically. This is useful for a quick check, but if you need to save the total or use it in other calculations, you need to create a formula in a cell.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.