The simplest way to sum a column

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

The colon between the two cell references tells Excel to include every cell in that range. You do not have to type each cell individually — the range does the work for you. This is the method you will use most often because it is fast and works whether you have 5 numbers or 500.

If your numbers are not in a neat vertical line, you can still sum them. Type =SUM(, then click on the first cell, hold Shift, and click on the last cell. Excel fills in the range for you. When you release Shift and press Enter, the sum appears in your formula cell.

Key Takeaways

  • The SUM function adds a range of cells: type =SUM(A1:A10) in an empty cell and press Enter to get the total.
  • The colon in A1:A10 means "all cells from A1 to A10" — you do not list each cell separately.
  • You can click and Shift-click to select the range instead of typing the cell references by hand.
  • If you need to add only certain cells that are not next to each other, use commas: =SUM(A1,A3,A5) adds only those three cells.
  • The formula bar at the top shows what you typed, so you can check it before pressing Enter.

Selecting the range by dragging

Many people find it easier to select cells by dragging than by typing. Click on the first number in your column, then hold down the mouse button and drag down to the last number. The cells highlight in blue as you drag. When you reach the last cell, release the mouse.

Now click on the empty cell below your selection and type =SUM(. You will see that Excel has already guessed the range you want — it shows something like A1:A10 in the formula. Type the closing parenthesis and press Enter. This method is faster if you can see all your numbers on screen at once.

Adding non-adjacent cells

Sometimes the numbers you want to add are scattered across the column, not in one block. You might want to sum only certain rows, or skip some rows in between. Use commas to separate the cells or ranges: =SUM(A1,A3,A7,A10) adds only those four cells, skipping A2, A4, A5, A6, A8, and A9.

You can also mix single cells and ranges in one formula. For example, =SUM(A1:A5,A10:A15) adds two separate blocks of cells. Click on the first cell, hold Ctrl (or Cmd on a Mac), then click on the other cells or ranges while holding Ctrl. When you type the formula, Excel fills in the commas for you.

Fixing common mistakes

The most common error is forgetting the equals sign at the start. If you type SUM(A1:A10) without the =, Excel treats it as text and displays your formula instead of calculating. Always start with =.

Another mistake is using the wrong cell reference. If you type =SUM(A1:B10), you are adding two columns instead of one. Check the formula bar to see exactly which cells you included. If it is wrong, click in the formula bar, fix the range, and press Enter again.

If your sum seems too high or too low, the range might include a cell with text or a blank space. Excel skips text cells automatically, but blank cells in the middle of your range can sometimes cause confusion. Click on each cell in your range to verify it contains a number.

Using AutoSum for speed

Excel has a shortcut button called AutoSum that guesses which cells you want to add. Click on the empty cell below your column of numbers, then look for the AutoSum button — it looks like a Greek sigma symbol (Σ) and is usually in the toolbar at the top. Click it, and Excel highlights the range it thinks you want to sum.

If the highlighted range is correct, press Enter and you are done. If it is wrong, you can click and drag to select the correct range, then press Enter. AutoSum saves time when your numbers are in a neat column, but it sometimes guesses wrong if your data has gaps or is arranged in an unusual way.

Summing across rows instead of down columns

The SUM function works the same way whether you are adding across a row or down a column. If your numbers run left to right across cells A1, B1, C1, and D1, type =SUM(A1:D1) in the cell to the right (E1). The colon still means "all cells in this range," whether the range is vertical or horizontal.

You can also sum a rectangular block of cells — for example, =SUM(A1:D10) adds all the numbers in a 4-by-10 grid. Excel adds every number in that rectangle, regardless of whether they are arranged in rows or columns. This is useful when you have a table of data and want a grand total.

Frequently Asked Questions

What if I add more numbers to my column after I write the formula?

If you add a number below your SUM range, the formula does not automatically include it. You have to edit the formula to extend the range. Click on the cell with the formula, click in the formula bar, change A1:A10 to A1:A11 (or however many rows you now have), and press Enter. To avoid this problem, make your range larger than you currently need.

Can I sum cells from different sheets in the same workbook?

Yes. Type =SUM(Sheet1.A1:A10,Sheet2.A1:A10) to add ranges from two different sheets. Replace Sheet1 and Sheet2 with the actual names of your sheets. The period separates the sheet name from the cell reference. This works the same way as summing cells on one sheet.

Why does my formula show in the cell instead of the answer?

You forgot the equals sign at the start. Excel treats anything without an equals sign as text. Click on the cell, click in the formula bar, add the = at the very beginning, and press Enter. The formula will calculate and show the sum.

Can I sum only cells that meet a certain condition?

Yes, but you need a different function called SUMIF. For example, =SUMIF(A1:A10,">100") adds only the cells in that range that are greater than 100. This is more advanced than basic SUM, but it works the same way — type the formula, press Enter, and Excel calculates the result.