The fastest way to total a column in Excel

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

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

The SUM function works the same way whether you have 5 numbers or 500. Once you press Enter, the total stays in that cell and updates automatically if you change any of the numbers above it.

Key Takeaways

  • Click an empty cell below your column, type =SUM(, select your range, type ), and press Enter to get a total.
  • You can type the range directly as =SUM(A2:A10) if you know which rows hold your numbers.
  • The total updates on its own whenever you change a number in the column.
  • SUM ignores empty cells and text, so it only adds actual numbers.
  • You can sum multiple separate ranges by typing =SUM(A2:A5,A10:A15) with commas between them.

Selecting your range by clicking and dragging

The easiest method for most people is to let Excel see which cells you want to add. Click on the empty cell where you want the total to appear. Type =SUM( and stop — do not close the parenthesis yet.

Now click on the first number in your column. You will see that cell highlight and its address appear in the formula bar at the top. Hold down your mouse button and drag down to the last number you want to include. As you drag, Excel shows you the range in the formula bar — something like A2:A10.

When you reach the last number, release the mouse button. Type ) to close the formula and press Enter. The total appears in your cell.

Typing the range directly when you know the cell addresses

If you can see which rows your numbers occupy, typing the range is often faster than dragging. Click the empty cell where you want the total. Type =SUM(A2:A10), replacing A with your column letter and 2 and 10 with your actual first and last row numbers.

The colon tells Excel that you want every cell from the first address to the second. So A2:A10 means "add A2, A3, A4, A5, A6, A7, A8, A9, and A10." You can use any column letter and any row numbers — =SUM(D5:D20) or =SUM(Z1:Z100) work exactly the same way.

Press Enter when you finish typing the formula. The total appears immediately.

Adding multiple separate ranges in one formula

Sometimes your numbers are not in one continuous block. You might have sales data in rows 2 through 5, a gap in row 6, and more sales in rows 8 through 12. You can add both ranges at once by separating them with a comma.

Type =SUM(A2:A5,A8:A12) to add the first group and the second group together. Excel treats this as one formula and shows a single total. You can include as many separate ranges as you need — =SUM(A2:A5,A8:A12,A15:A20) works just as well.

What SUM does and does not add

SUM adds only numbers. If a cell contains text, a space, or is completely empty, SUM ignores it. This is useful because it means you can include rows that might be blank without breaking your formula.

If you have a cell that says "Total" or "Sales" in your range, SUM skips it and only adds the actual numbers. This is why you can often select a large range without worrying about headers or labels mixed in.

Checking your formula in the formula bar

After you press Enter, click on the cell with your total. Look at the formula bar at the top of the screen — it shows the formula you created, like =SUM(A2:A10). This is useful for checking that you included the right range, especially if you dragged to select it.

If you need to change the range, you can click in the formula bar, edit the cell addresses, and press Enter again. The total updates to match your new range.

Using AutoSum for the fastest method

Excel has a button called AutoSum that does the clicking and typing for you. Click on an empty cell below your column of numbers. Look for the AutoSum button in the toolbar — it looks like the Greek letter Sigma (Σ) and is usually in the top ribbon near the left side.

Click AutoSum and Excel guesses which range you want to add. Most of the time it gets it right and creates a SUM formula for you instantly. If it picked the wrong range, you can still edit it in the formula bar before pressing Enter.

Frequently Asked Questions

What if my numbers are in a row instead of a column?

SUM works exactly the same way. If your numbers run across row 5 from column A to column E, type =SUM(A5:E5). The colon still means "from the first cell to the last cell," whether you are moving down or across.

Can I sum a column that has both positive and negative numbers?

Yes. SUM adds everything together, treating negative numbers as subtraction. So =SUM(A2:A10) with values like 100, -50, and 75 will give you the correct total of 125.

What happens if I change a number in the column after I create the SUM formula?

The total updates automatically. Excel recalculates the formula whenever any number in the range changes, so you always see the current total without doing anything else.

Can I sum numbers from different columns at the same time?

Yes, by using commas to separate the ranges. Type =SUM(A2:A10,C2:C10) to add column A and column C together in one total. You can include as many separate ranges as you need.

Does SUM include the cell with the formula itself?

No. If you put the SUM formula in cell A11, it will not try to add A11 to the total, even if A11 is technically in the range. Excel is smart enough to avoid this circular problem.