The simplest way to add a column of numbers

To add numbers in an Excel column, click on the empty cell below the last number you want to add, then type =SUM( followed by the range of cells you want to add. For example, if your numbers are in cells A1 through A10, you would type =SUM(A1:A10) and press Enter. Excel will when ready show you the total.

The colon between the two cell references tells Excel to include every cell from the first one to the second one. So A1:A10 means "add A1, A2, A3, all the way through A10." This works the same way whether your numbers are in a column going down or a row going across.

You do not need to type the cell references by hand. After you type =SUM(, you can click on the first cell you want to add, hold Shift, and click on the last cell. Excel will fill in the range for you, and you just press Enter to finish.

Key Takeaways

  • The SUM function adds a range of cells: type =SUM(A1:A10) to add cells A1 through A10.
  • You can click and drag to select the cells instead of typing the range by hand.
  • The result appears in the cell where you typed the formula, not in the cells you added.
  • If you add a new number to the column later, the total updates automatically as long as the new number is within the original range.
  • You can add multiple separate ranges in one formula: =SUM(A1:A5,C1:C5) adds two different sections.

Selecting the cells you want to add

The most common mistake is selecting the wrong range. Before you type the formula, count which row your first number is in and which row your last number is in. If your numbers start in row 2 (because row 1 has a label) and end in row 15, your range is A2:A15, not A1:A15.

If your numbers are not in one continuous block — for example, you have numbers in A1 through A5 and also in A10 through A15 — you can add both ranges in one formula. Type =SUM(A1:A5,A10:A15). The comma tells Excel to add the first range, then add the second range, then show you the combined total.

If you are not sure which cells contain numbers, click on the first cell with a number and look at the cell reference box at the top left of the screen. It will show you the letter and number of that cell. Then click on the last cell and note its reference. That gives you the range you need.

Where to put the total and why it matters

Put the SUM formula in an empty cell, usually the one directly below the last number in your column. This keeps your data organized and makes it straightforward to see where the total is. If you put the formula in a cell that already has a number in it, that number will disappear and be replaced by the total.

The cell you choose for the formula does not have to be in the same column as the numbers you are adding. You could put the total in a different column or even a different sheet if you wanted to. But keeping it close to the data you added makes the spreadsheet easier to read later.

What happens when you change a number

If you change one of the numbers in your range, the total updates when ready. For example, if you have =SUM(A1:A10) and you change the value in A5 from 100 to 150, the total will increase by 50 right away. You do not have to re-enter the formula or do anything else — Excel watches the cells and recalculates automatically.

This also means that if you add a new number to your column later, it will only be included in the total if it falls within the range you originally typed. If your formula is =SUM(A1:A10) and you add a number in A11, that new number will not be added to the total. You would need to edit the formula to =SUM(A1:A11) to include it. To avoid this problem, you can make your range slightly larger than you think you need, so new numbers will be included automatically.

Adding numbers across multiple columns

If your numbers are arranged in rows instead of columns — for example, you have numbers in A1, B1, C1, and D1 — you use the same SUM function. Type =SUM(A1:D1) and Excel will add all four numbers. The colon still means "from the first cell to the last cell," whether you are moving down or across.

You can also add numbers from a rectangular block that includes multiple rows and columns. If you have numbers in cells A1 through D5 (a 4-by-5 rectangle), you can type =SUM(A1:D5) and Excel will add all 20 cells. This is useful when you have a table of data and want to know the grand total of everything in it.

Other ways to work with column numbers

SUM is the most common function, but Excel has others that work the same way. AVERAGE(A1:A10) finds the middle value of your numbers. COUNT(A1:A10) tells you how many cells contain numbers (useful if you are not sure how many rows you have). MAX(A1:A10) shows the largest number, and MIN(A1:A10) shows the smallest.

All of these functions use the same syntax: the function name, followed by the range in parentheses. If you want to add numbers and also see the average, you can put both formulas in different cells. For example, put =SUM(A1:A10) in cell A12 and =AVERAGE(A1:A10) in cell A13. Both will work independently and show different results.

Frequently Asked Questions

What if I have text mixed in with my numbers?

SUM ignores text cells and only adds the numbers. If you have a column with numbers, labels, and blank cells mixed together, SUM will skip over the text and blanks and add only the numbers it finds. This is usually what you want, but double-check your result to make sure it looks right.

Can I add numbers from different sheets in the same workbook?

Yes. Type =SUM(Sheet1.A1:A10,Sheet2.A1:A10) to add a range from Sheet1 and a range from Sheet2 in one formula. The period separates the sheet name from the cell range. Make sure you spell the sheet name exactly as it appears on the sheet tab at the bottom of the screen.

Why does my formula show as text instead of a number?

This usually means the cell is formatted as text. Right-click the cell, choose Format Cells, and change the format to Number. Then press Enter to recalculate the formula. If the formula still does not work, delete it and type it again in the reformatted cell.

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

Use SUMIF instead of SUM. For example, =SUMIF(A1:A10,">100") adds only the numbers in A1 through A10 that are greater than 100. The condition goes in quotes after the range. This is useful when you have a large list and want to total only part of it.

What if my column is very long and I do not want to type the whole range?

Click on the first cell with a number, then hold Shift and press Ctrl+Down (on Windows) or Command+Down (on Mac). Excel will jump to the last cell with data in that column. Then type your formula. Alternatively, you can click on the column header letter to select the entire column, and =SUM(A:A) will add every number in column A.