The fastest way to sum a column

Click the empty cell below the numbers you want to add. Type =SUM(, then click the first number in your column and drag down to the last one. When you release, type ) and press Enter. Excel shows the total in that cell.

If your numbers are in column A from row 2 to row 10, you can also type =SUM(A2:A10) directly into the cell and press Enter. The colon tells Excel to add everything between those two cells.

You do not have to type the range yourself. Excel can often figure out which column you want to sum. Click the cell below your numbers, go to the Home tab at the top, find the AutoSum button (it looks like a Greek sigma, or Σ), and click it. Excel highlights the cells it thinks you want to add and shows the sum. Press Enter to accept it.

Key Takeaways

  • The SUM function adds all the numbers in a range: type =SUM(A2:A10) to add cells A2 through A10.
  • Click below your column of numbers, then click the AutoSum button on the Home tab to let Excel find the range for you.
  • You can sum non-consecutive cells by typing =SUM(A2,A5,A8) to add only specific cells instead of a whole range.
  • If you want to add numbers across a row instead of down a column, the method is the same — just select cells left to right instead of top to bottom.

Using AutoSum when your data has headers

If your first row contains a label like "Sales" or "Quantity" instead of a number, AutoSum still works. Click the empty cell below your last number, click the AutoSum button, and Excel skips the header row automatically. It highlights only the cells with actual numbers.

If AutoSum highlights the wrong range — for example, if there is a blank row in the middle of your data — you can fix it before pressing Enter. Click and drag to select only the cells you actually want to add, then press Enter.

Adding specific cells instead of a whole range

Sometimes you do not want to add every cell in a column. You might want to sum only certain rows, or skip a row that contains a subtotal. Use the SUM function with commas instead of a colon.

Type =SUM(A2,A5,A8) to add only cells A2, A5, and A8. You can list as many individual cells as you need, separated by commas. This is useful when your data is scattered or when you want to exclude certain rows from the total.

Summing multiple columns at once

If you have numbers in columns A and B and you want one total that includes both, type =SUM(A2:A10,B2:B10). The comma tells Excel to add the first range and then add the second range to that total.

You can also select a range that spans multiple columns. Click the first cell you want to include, hold Shift, and click the last cell. Then type =SUM( and the range appears automatically. This works for any rectangular block of cells, whether it is one column wide or ten columns wide.

Fixing common SUM mistakes

If your sum shows as zero or a very small number, check whether Excel is treating your numbers as text instead of actual numbers. Text that looks like numbers will not add up. Look at the cells — if the numbers are left-aligned instead of right-aligned, they are probably text. You can fix this by reformatting the column as a number: right-click the column header, choose Format Cells, and select Number from the list.

If your formula shows as text in the cell instead of showing a result, the cell is probably formatted as text. Right-click the cell, choose Format Cells, select General or Number, and press Enter. Then click the cell again and press Enter to recalculate.

If you see #REF! or another error, the formula is referring to cells that no longer exist — usually because you deleted rows or columns. Click the cell with the error, look at the formula bar at the top, and fix the range to point to the correct cells.

Summing a column that grows over time

If you add new numbers to your column regularly, you can write a formula that automatically includes them. Instead of typing a specific range like A2:A10, use a larger range that has room for future data: =SUM(A2:A1000). This adds all numbers in that range, whether there are 10 numbers or 500.

Another option is to use the SUBTOTAL function if you plan to filter or hide rows. Type =SUBTOTAL(9,A2:A1000) — the 9 tells Excel to sum only the visible cells, ignoring any rows you have hidden or filtered out. This is useful in spreadsheets where you show and hide data depending on what you are looking at.

Frequently Asked Questions

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

Yes. Type =SUM(Sheet1!A2:A10,Sheet2!A2:A10) to add a range from Sheet1 and a range from Sheet2 in the same total. The exclamation point tells Excel which sheet to look in. You can add as many sheets as you need by separating them with commas.

What if I want to add only numbers that meet a certain condition?

Use SUMIF instead of SUM. Type =SUMIF(A2:A10,">100") to add only numbers greater than 100, or =SUMIF(A2:A10,"red") to add only cells that contain the word "red". This is useful when you want a total of sales above a certain amount or expenses in a specific category.

Why does my sum change when I add a new row?

If you typed a specific range like =SUM(A2:A10), adding a new row below row 10 will not be included in the sum. Use a larger range like =SUM(A2:A1000) instead, or insert new rows in the middle of your existing data rather than at the bottom — Excel will expand the range automatically.

Can I see the sum without creating a formula in a cell?

Yes. Select the cells you want to add, and look at the bottom right of the screen — Excel shows the sum, average, and count in the status bar. This is a quick way to check a total without writing a formula, though the result disappears when you click elsewhere.