Adding cells in Excel means selecting the ones you want and using a formula to combine their values

The most common way to add cells is the SUM function. You type =SUM( then click or type the cells you want to add, then close the parenthesis with ). Excel adds them up and shows the total in the cell where you typed the formula. If you want to add cells A1, A2, and A3, you would type =SUM(A1:A3) — the colon tells Excel to include everything from A1 through A3.

You can also add just two cells with a plus sign: =A1+A2. This works fine for a handful of cells, but SUM is faster when you have many rows or columns to combine. Both methods give you the same answer — it is just a matter of what is easier to type.

The cells you add do not have to be next to each other. You can add A1, C5, and E10 all in one formula by typing =A1+C5+E10 or =SUM(A1,C5,E10). Notice the comma separates cells that are not in a row or column together.

Key Takeaways

  • SUM is the fastest way to add many cells at once: type =SUM(A1:A3) to add cells A1 through A3.
  • A colon between two cell names (A1:A3) tells Excel to add everything in that range; a comma (A1,C5) adds only the cells you name.
  • You can add cells that are not next to each other by separating them with commas in the same formula.
  • A straightforward plus sign (=A1+A2) works for two or three cells but becomes slow to type when you have many rows to combine.
  • The formula goes in the cell where you want the answer to appear, and Excel updates it automatically if you change any of the numbers being added.

Using SUM to add a range of cells in one row or column

Open your spreadsheet and click the cell where you want the total to appear. Type =SUM( and then click the first cell you want to add. Hold Shift and click the last cell in the range. Excel highlights all the cells between them. Type the closing parenthesis ) and press Enter. The total appears in your cell.

If you prefer typing instead of clicking, you can type the range directly. Type =SUM(A1:A10) to add cells A1 through A10. The colon is the key — it tells Excel to include every cell from the first one to the second one. You can do the same with columns: =SUM(B1:B50) adds every cell in column B from row 1 to row 50.

After you press Enter, the formula stays in the cell. If you click on the cell again, you see the formula in the formula bar at the top of the screen. If any of the numbers in those cells change, Excel recalculates the total automatically.

Adding cells that are not next to each other

Sometimes the cells you need are scattered across the spreadsheet. You might need to add A2, C5, and E8 — cells with nothing in common except that you want their total. Use commas to separate them: =SUM(A2,C5,E8). Excel adds only those three cells, ignoring everything else.

You can also mix ranges and individual cells in the same formula. If you want to add cells A1 through A5 and also cell D10, type =SUM(A1:A5,D10). Excel adds all five cells in the range plus the one cell you named separately.

This works with as many cells as you need. Just keep separating them with commas and Excel will add them all together.

Adding two cells with a plus sign

For a quick total of just two cells, you can skip SUM and type =A1+A2. This is faster to type than =SUM(A1:A2) when you only have two numbers. Press Enter and the total appears.

You can chain plus signs together for three or four cells: =A1+A2+A3+A4. But once you get to five or more cells, SUM becomes easier because you do not have to type a plus sign between every single one. With SUM you just type the range once and you are done.

Copying a formula to other cells

After you create a formula in one cell, you can copy it to other cells and Excel adjusts the cell names automatically. Click the cell with your formula. At the bottom right corner of the cell, you see a small square — this is the fill handle. Click and drag it down or to the right to copy the formula to the cells below or beside it.

If your formula is =SUM(A1:A3) in cell B1, and you drag the fill handle down to B2, Excel changes it to =SUM(A2:A4). It shifts the range down by one row. This is useful when you have many rows of data and want to add each row separately without typing the formula over and over.

You can also copy and paste. Click the cell with the formula, press Ctrl+C (or Cmd+C on a Mac), then click the cell where you want it and press Ctrl+V. Excel adjusts the cell names in the same way.

Adding cells with different data types

Excel can add cells that contain whole numbers, decimals, and negative numbers all in the same formula. If A1 has 10, A2 has 5.5, and A3 has -2, then =SUM(A1:A3) gives you 13.5. Excel treats negative numbers as subtraction automatically.

If a cell contains text instead of a number, Excel ignores it. If A1 has "Sales" and A2 has 100, then =SUM(A1:A2) returns 100 — it skips the text and adds only the number. This means you can have labels mixed in with your data and the formula still works.

If a cell is empty, Excel treats it as zero. So =SUM(A1:A5) works the same whether A3 is blank or contains 0.

Fixing common mistakes when adding cells

The most common error is forgetting the equals sign at the start. If you type SUM(A1:A3) without the = sign, Excel treats it as text and does not calculate anything. Always start with =.

Another mistake is using the wrong bracket type. Excel formulas use parentheses ( ), not square brackets [ ] or curly braces { }. If you type =SUM[A1:A3], Excel shows an error.

If your formula shows an error like #REF! or #VALUE!, it usually means a cell you are trying to add contains text that Excel cannot convert to a number, or you deleted a cell that the formula was using. Click on the cell with the error and check the formula in the formula bar to see which cells it is trying to add.

Frequently Asked Questions

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

Yes. Type the sheet name, then an exclamation point, then the cell name: =SUM(Sheet1!A1:A5,Sheet2!A1:A5). This adds the range A1:A5 from Sheet1 and the same range from Sheet2. Make sure the sheet name matches exactly, including capital letters.

What is the difference between =A1+A2 and =SUM(A1:A2)?

They give the same answer, but SUM is faster when you have many cells. The plus sign method requires you to type a plus between every cell, while SUM lets you type a range once. For two or three cells, either works fine.

Does the order of cells matter when I add them?

No. =SUM(A1:A5) and =SUM(A5:A1) give the same total. Excel adds them in the order it finds them, so the direction does not change the result. The same is true with the plus sign: =A1+A2 and =A2+A1 are equal.

What happens if I add cells that contain formulas?

Excel adds the results of those formulas, not the formulas themselves. If A1 contains =5+5 (which shows 10) and A2 contains 20, then =SUM(A1:A2) returns 30. Excel uses the calculated value, not the formula text.

Can I add cells and also subtract or multiply in the same formula?

Yes. You can type =SUM(A1:A5)+B1 to add A1 through A5 and then add B1 to that total. You can also type =SUM(A1:A5)*2 to add them and then multiply the result by 2. Excel follows standard math order: multiplication and division happen before addition and subtraction.