The fastest way to add a column

Click on an empty cell directly below the last number in your column. Type =SUM( then click on the first number in the column, hold Shift, and click on 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 type =SUM(A2:A10) directly into the empty cell and press Enter. Either method takes about five seconds and works whether you have 5 numbers or 500.

Key Takeaways

  • The SUM function adds all numbers in a range you select, and you can type it or build it by clicking and dragging.
  • Always put the total in an empty cell below or to the side of your numbers, not in a cell that contains data you want to keep.
  • If you add new numbers to the column later, you can drag the formula down to include them, or edit the formula to extend the range.
  • Excel shows you the sum automatically in the status bar at the bottom right when you select a range of numbers, even without creating a formula.

Using the SUM function with the mouse

This method works best if you are not comfortable typing cell references. Click on the empty cell where you want the total to appear. Type =SUM( and stop — do not press Enter yet.

Now click on the first number in your column. You will see that cell reference appear in your formula. Hold down Shift and click on the last number in the column. Excel highlights the entire range in blue. Type ) to close the formula and press Enter. Your total appears instantly.

This approach is less error-prone because you are pointing at the cells instead of typing their names. If you make a mistake, press Escape before you hit Enter, and start over.

Typing the formula directly

If you know which cells hold your numbers, you can type the whole formula at once. Click on the empty cell for your total. Type =SUM(A2:A10) where A2 is your first number and A10 is your last. The colon between them means "from A2 through A10, including everything in between."

Press Enter and the total appears. This method is faster once you get used to it, and it works the same way whether your numbers are in a column or a row. For a row, use =SUM(A2:E2) instead.

What to do when you add more numbers later

If you created a SUM formula and then add new numbers below it, the formula will not automatically include them. You have two choices: edit the formula or move it down.

To edit the formula, click on the cell that contains your total. Look at the formula bar at the top — it shows =SUM(A2:A10) or whatever your range is. Click in the formula bar and change A10 to A15 (or however many rows you now have). Press Enter and the total updates to include the new numbers.

To move the formula instead, click on the cell with the total and drag it down to sit below your new last number. The formula adjusts automatically. This is faster if you are adding just a few more rows.

Reading the quick total at the bottom of the screen

You do not always need to create a formula. When you select a range of numbers in Excel, the status bar at the very bottom right of your screen shows the sum, average, and count automatically. This is useful for a quick check without cluttering your spreadsheet with extra cells.

Click on your first number, hold Shift, and click on your last number. Look at the bottom right corner. You will see "Sum: 1250" or whatever your total is. This disappears as soon as you click somewhere else, so use it only when you need a one-time answer.

Common mistakes to avoid

The most common error is putting your formula in a cell that already contains a number you want to keep. Always use a truly empty cell — usually the row right below your last number. If you accidentally overwrite data, press Ctrl+Z immediately to undo.

Another mistake is forgetting to close the parenthesis. If you type =SUM(A2:A10 without the closing ), Excel shows an error. Just click in the formula bar, add the ) at the end, and press Enter.

Do not include the cell with your total in the range itself. If your numbers are in A2 through A10 and your total is in A11, use =SUM(A2:A10), not =SUM(A2:A11). Including A11 creates a circular reference and Excel will warn you.

Adding multiple separate columns at once

If you have several columns of numbers and want a total for each one, you can create all the formulas in a single row. Click on the empty cell below the first column. Type =SUM(A2:A10) and press Enter. Now click on that cell again and look for the small square in the bottom right corner of the cell.

Drag that square to the right across as many columns as you have data. Excel copies the formula and adjusts it automatically — the second column becomes =SUM(B2:B10), the third becomes =SUM(C2:C10), and so on. This saves time when you are working with a large table.

Frequently Asked Questions

Can I add numbers that are in different columns?

Yes. Type =SUM(A2:A10,C2:C10) to add column A and column C but skip column B. Use commas to separate the ranges. You can add as many separate ranges as you need.

What if some cells are empty?

SUM ignores empty cells completely. If A2 through A10 contains numbers in some cells and blanks in others, =SUM(A2:A10) adds only the cells with numbers. This is usually what you want.

How do I add only numbers that meet a certain condition?

Use SUMIF instead of SUM. For example, =SUMIF(A2:A10,">100") adds only the numbers greater than 100. Type the condition in quotes after the range.

Can I see the formula I used after I create it?

Click on the cell that contains your total. The formula bar at the top shows exactly what formula is in that cell. You can edit it there or just read it to check your work.

What if my numbers have dollar signs or commas in them?

SUM works fine with formatted numbers. Excel ignores the dollar signs and commas and adds only the actual values. The total appears in whatever format you set for that cell.