The fastest way to sum a column

Click the empty cell directly below the last number in your column. Type =SUM(, then click the first number in the column, hold Shift, and click the last number. Type ) and press Enter. Excel will add them all up and show the total in that cell.

If your column is A2 through A10, you can also just type =SUM(A2:A10) directly into the empty cell and press Enter. Both methods give you the same result — the sum appears in the cell, and Excel remembers the formula if you need to change any of the numbers later.

Key Takeaways

  • The SUM function adds all numbers in a range you select, and you can build it by clicking cells or by typing the cell addresses directly.
  • The colon between two cell addresses (like A2:A10) tells Excel to include every cell from the first one to the second one.
  • Once you enter a SUM formula, Excel updates the total automatically if you change any of the numbers in that range.
  • You can sum multiple separate columns by adding a plus sign between ranges, like =SUM(A2:A10)+SUM(C2:C10).

Clicking your way through the formula

This method works best if you are not sure which cells to include or if your data is scattered. Click the cell where you want the answer to appear — usually the row right below your last number. Type =SUM( and stop.

Now click the first cell with a number in your column. You will see it appear in the formula bar at the top. Hold Shift and click the last cell with a number. Excel highlights all the cells between them in blue. Type ) to close the formula and press Enter. The sum appears in your cell.

This method is slower than typing, but it prevents mistakes because you can see exactly which cells are included before you press Enter.

Typing the cell range directly

If you know which cells hold your numbers, typing is faster. Click the empty cell below your column. Type =SUM(, then the address of the first cell, a colon, and the address of the last cell. For example, =SUM(B5:B22) adds every number from B5 down to B22. Press Enter.

The colon is the key — it tells Excel "include this cell, that cell, and every cell in between." If you type =SUM(B5,B22) with a comma instead, Excel only adds those two cells and ignores everything in the middle.

What happens when you change a number

One reason to use SUM instead of adding numbers by hand is that Excel updates the total automatically. If you change any number in the range you summed, the total in your SUM cell changes when ready. This saves time if you are building a budget or tracking expenses and numbers shift.

You can see the formula that created the total by clicking on the cell with the sum. The formula bar at the top shows =SUM(A2:A10) or whatever range you used. This is how you know which cells are being added — and how you can fix it if you included the wrong range.

Summing multiple columns at once

If you need to add up column A and column C but skip column B, use a plus sign to combine two SUM formulas. Type =SUM(A2:A10)+SUM(C2:C10). Excel adds all the numbers in A2 through A10, then adds all the numbers in C2 through C10, and shows you the grand total.

You can also add individual cells to a SUM. For example, =SUM(A2:A10)+D5 adds the range A2:A10 plus the single cell D5. This is useful when one number lives outside your main column.

Common mistakes and how to fix them

The most common error is including a header row — the row with a label like "Expenses" or "Sales." If your numbers start in A2 but your header is in A1, make sure your formula says =SUM(A2:A10), not =SUM(A1:A10). Excel will try to add the text in A1 as a number, which it cannot do, so it ignores it — but it is cleaner to exclude it from the start.

Another mistake is forgetting the colon. =SUM(A2 A10) with a space will not work. =SUM(A2,A10) with a comma adds only those two cells. Always use a colon to mean "from this cell to that cell."

If your sum shows as 0 or a very small number when you expected something larger, check whether your column contains actual numbers or text that looks like numbers. Excel treats "100" typed as text differently from the number 100. Look at how the numbers line up in their cells — numbers align to the right by default, text to the left.

Frequently Asked Questions

Can I sum a column that has empty cells in the middle?

Yes. SUM skips empty cells and adds only the numbers it finds. If A2 has 10, A3 is empty, and A4 has 20, then =SUM(A2:A4) gives you 30. This is why SUM is safer than trying to add cells one by one by hand.

What if I want to sum only numbers that are bigger than 100?

Use SUMIF instead of SUM. Type =SUMIF(A2:A10,">100") to add only numbers larger than 100 in that range. The quotes around ">100" are required. You can also use "<100" for less than, "=100" for exactly 100, or any other condition.

How do I sum a column that goes down to row 1000?

Type the range the same way: =SUM(A2:A1000). Excel handles large ranges without any problem. If you are not sure where your data ends, click the first cell, press Ctrl+Shift+End (or Cmd+Shift+End on Mac), and Excel will select to the last cell with data in that direction.

Can I put the sum formula in a different sheet?

Yes. If your numbers are in Sheet1 column A, you can put the sum in Sheet2 by typing =SUM(Sheet1.A2:A10). Use a period to separate the sheet name from the cell range. On Mac, use an exclamation mark instead: =SUM(Sheet1!A2:A10).

What if my column has negative numbers?

SUM adds them correctly — negative numbers subtract from the total. If A2 is 50, A3 is -20, and A4 is 30, then =SUM(A2:A4) gives you 60. This is the expected behavior and usually what you want.