The simplest way to add cells in Excel

To add two or more cells together in Excel, type an equals sign, then the cell addresses you want to add, separated by plus signs. For example, if you want to add the value in cell A1 to the value in cell B1, type =A1+B1 in any empty cell and press Enter. Excel will show you the sum.

You can add as many cells as you need this way. If you want to add A1, B1, C1, and D1 together, type =A1+B1+C1+D1. The equals sign tells Excel you are entering a formula, not just text.

The cell where you type the formula is where the answer appears. If you type the formula in cell E1, the sum will show up in E1, and the original numbers in A1 through D1 stay unchanged.

Key Takeaways

  • Start every formula with an equals sign, then list the cells you want to add separated by plus signs.
  • The SUM function is faster than typing plus signs when you are adding many cells in a row or column.
  • You can copy a formula down or across to repeat the same calculation for different rows or columns.
  • Excel recalculates the sum automatically if you change any of the numbers in the cells you are adding.

Using the SUM function for longer lists

When you have many cells to add — say, ten or twenty in a row — typing each cell address with a plus sign becomes tedious. The SUM function does the same thing faster. Type =SUM(A1:A10) to add all cells from A1 through A10. The colon between the two addresses tells Excel to include everything in between.

You can also use SUM for cells that are not in a straight line. Type =SUM(A1,C1,E1) to add only those three specific cells, skipping the ones in between. Use commas to separate cell addresses that are not next to each other.

SUM works the same way as typing plus signs — it adds the numbers and shows the result in the cell where you typed the formula. If any of those numbers change, the sum updates automatically.

Copying a formula to other rows or columns

Once you have written a formula in one cell, you can copy it to other cells and Excel will adjust the addresses automatically. If you type =A1+B1 in cell C1, then copy that formula down to C2, Excel changes it to =A2+B2. This saves you from typing the same formula over and over.

To copy a formula, click the cell that contains it, then drag the small square in the bottom right corner of the cell down or across to the cells where you want the formula to go. Excel will adjust each formula to match its row or column. You can also copy the cell (Ctrl+C on Windows, Command+C on Mac), select the range where you want it, and paste (Ctrl+V or Command+V).

Adding cells from different sheets

If your numbers are on different sheets in the same workbook, you can still add them together. Type the sheet name, then an exclamation point, then the cell address. For example, =Sheet1!A1+Sheet2!A1 adds the value in A1 from Sheet1 to the value in A1 from Sheet2.

If the sheet name has a space in it, put the name in single quotes: ='Sales Data'!A1+B1. This tells Excel that "Sales Data" is one sheet name, not two separate things.

Fixing common mistakes

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

Another mistake is using the wrong cell addresses. If you meant to add A1 and B1 but typed A1 and B2 by accident, the formula will still work — it will just add the wrong cells. Double-check that you are referencing the cells you actually want to add. You can click on a cell address in your formula and Excel will highlight which cell it refers to.

If your formula shows an error like #VALUE! or #REF!, it usually means you are trying to add cells that contain text instead of numbers, or you referenced a cell that no longer exists. Check that all the cells in your formula contain numbers, not words.

When to use SUM versus typing plus signs

For two or three cells, typing plus signs is fine: =A1+B1+C1 is quick and clear. For four or more cells in a continuous range, SUM is faster and easier to read: =SUM(A1:A4) is simpler than =A1+B1+C1+D1.

SUM also makes it easier to spot mistakes. If you are adding ten cells and one of them is wrong, it is harder to find the error in a long string of plus signs than in a SUM formula where you can see the range at a glance.

Frequently Asked Questions

Can I add cells that have formulas in them?

Yes. Excel adds the result of the formula, not the formula itself. If cell A1 contains =5+5 (which shows 10), and you type =A1+B1, Excel adds 10 plus whatever is in B1. The formula inside A1 does not matter — only the number it produces.

What happens if I add cells with blank spaces?

Excel treats blank cells as zero. If A1 has 5, A2 is blank, and A3 has 3, then =SUM(A1:A3) gives you 8. The blank cell does not break the formula or cause an error.

Can I add cells if some contain negative numbers?

Yes. Excel adds negative numbers the same way it adds positive ones. If A1 has 10 and B1 has -3, then =A1+B1 gives you 7. Negative numbers subtract from the total automatically.

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

Use the SUMIF function. For example, =SUMIF(A1:A10,">5") adds only the cells in A1 through A10 that contain a number greater than 5. This is useful when you want to total only part of a list based on a rule you set.

What if I want to add the same cell multiple times?

Type the cell address as many times as you need. =A1+A1+A1 adds the value in A1 three times. Or use multiplication: =A1*3 multiplies the value in A1 by 3, which gives the same result and is faster to type.