The fastest way to sum a column

To add up a column in Excel, click on an empty cell below the numbers you want to total, type =SUM( followed by the range of cells, then close with a parenthesis. For example, if your numbers are in cells A1 through A10, you would type =SUM(A1:A10) and press Enter. Excel calculates the total instantly.

The colon between the two cell references tells Excel to include every cell in that range. You do not have to type each cell individually — the range does all the work for you.

Key Takeaways

  • Click the empty cell where you want the total to appear, usually at the bottom of the column.
  • Type =SUM( followed by the first cell, a colon, the last cell, and a closing parenthesis — for example, =SUM(A1:A10).
  • Press Enter and Excel shows the sum; the formula stays in the cell so you can see it in the formula bar at the top.
  • You can also click and drag to select the range instead of typing the cell references, which is faster if the column is long.

Selecting the range by clicking and dragging

If typing cell references feels awkward, you can point and click instead. Type =SUM( in the empty cell, then click on the first number in your column and drag down to the last number. Excel highlights the range as you drag, and when you release the mouse, the cell references appear automatically in your formula.

This method is especially useful when you have a long column and do not want to count rows or guess which cell is which. The visual feedback also helps you catch mistakes — if you see the highlight skip over a number you meant to include, you can drag again to fix it.

Using the AutoSum button for one-click totals

Excel has a built-in shortcut called AutoSum that does the work for you. Click on the empty cell below your column of numbers, then look for the AutoSum button in the toolbar — it looks like the Greek letter sigma (Σ) and is usually in the Home tab on the ribbon at the top. Click it once, and Excel automatically creates a SUM formula for the column above.

AutoSum usually guesses correctly which cells to include, but always check the highlighted range before you press Enter. If it selected the wrong cells, you can adjust by clicking and dragging to the correct range, or just delete the formula and type it yourself.

What to do if your column has blank cells or text

SUM ignores blank cells and text automatically, so you do not have to clean them out first. If a cell contains the word "Total" or a dash or nothing at all, SUM skips right over it and adds only the numbers. This means you can safely include a few blank rows in your range without affecting the result.

However, if a cell contains text that looks like a number — for example, the number 5 stored as text instead of as a number — SUM will not count it. The cell appears to hold a number, but Excel treats it as text. If your total seems too low, check whether any cells are left-aligned instead of right-aligned; left alignment usually means the cell contains text, not a number.

Copying a formula down to multiple rows

If you have several columns of numbers and want to total each one, you do not have to type the formula separately for each column. Create the SUM formula in the first column, then click on that cell and copy the formula down to the other columns. Excel adjusts the cell references automatically — the formula in column B becomes =SUM(B:B), the formula in column C becomes =SUM(C:C), and so on.

To copy the formula, click on the cell containing your SUM formula, then drag the small square at the bottom-right corner of the cell across to the other columns. You can also copy the cell (Ctrl+C on Windows, Command+C on Mac), select the range where you want the formula, and paste (Ctrl+V or Command+V).

Summing non-adjacent cells or ranges

Sometimes the numbers you want to add are not in one continuous column. You might have data in cells A1 through A5, then a gap, then more data in A10 through A15. To sum both ranges at once, type the ranges separated by a semicolon or comma (depending on your region). For example, =SUM(A1:A5;A10:A15) or =SUM(A1:A5,A10:A15) adds both groups together.

Check your regional settings to know whether to use a semicolon or comma — most English-language versions of Excel use a comma, but some European versions use a semicolon. If your formula does not work, try the other separator.

Checking your formula and fixing common mistakes

After you press Enter, click on the cell containing your formula to see it in the formula bar at the top of the screen. This shows you exactly what Excel is adding up. If the total looks wrong, the formula bar tells you which cells are included — you can spot a typo or a missing row immediately.

The most common mistake is using the wrong cell references. For example, typing =SUM(A1:A9) when you meant =SUM(A1:A10) leaves out the last number. Another common error is including a header row that contains text instead of a number — SUM ignores the text, but it is cleaner to start your range at the first actual number. If you need to include a label, put it in a separate row above your data.

Frequently Asked Questions

Can I sum a column if the numbers are in different sheets?

Yes. Type the sheet name followed by an exclamation point before the cell reference — for example, =SUM(Sheet1!A1:A10). If the sheet name contains a space, put it in single quotes: =SUM('Sheet 1'!A1:A10). This works the same way as summing cells in the current sheet.

What is the difference between SUM and SUBTOTAL?

SUM adds every number in the range. SUBTOTAL adds only the visible cells if you have hidden rows or filtered data. If you have filtered a list to show only certain rows, use SUBTOTAL to total only what you see on screen. SUM would still add the hidden rows, which is usually not what you want.

How do I sum a column if the numbers are formatted as currency or percentages?

SUM works the same way regardless of formatting. The number 5 formatted as $5.00 or 500% is still just the number 5 to Excel. Format your total cell the same way as your data — click the cell, then use the formatting buttons in the Home tab to match the style.

Can I use SUM in a formula with other math operations?

Yes. You can type =SUM(A1:A10)+B1 to add the column and then add another cell, or =SUM(A1:A10)*2 to double the total. Excel calculates the SUM first, then performs the other operation. Use parentheses if you need to control the order — for example, =(A1+A2)*SUM(B1:B10).

What happens if I delete a number from the column after I create the formula?

The formula updates automatically. If you delete a number, the total decreases. If you add a new number to the range, the total increases. The formula stays the same, but the result changes based on what is currently in those cells.