The simplest way to add in Excel

To add numbers in Excel, type an equals sign, then the numbers or cell references you want to add, separated by plus signs. For example, =5+3 gives you 8. If your numbers are already in cells — say cell A1 contains 100 and cell B1 contains 50 — type =A1+B1 to add them together.

Excel treats anything that starts with an equals sign as a formula. Without that equals sign, Excel reads what you type as text and won't do any math. Once you type the formula and press Enter, Excel shows you the result in that cell.

This works the same way in Excel on Windows, Excel on Mac, and Google Sheets. The equals sign is the one rule that never changes.

Key Takeaways

  • Every formula in Excel starts with an equals sign, followed by the numbers or cell addresses you want to add.
  • The SUM function adds a whole range of cells at once and is faster than typing individual cell references with plus signs.
  • You can add cells from different sheets by typing the sheet name, then an exclamation point, then the cell address.
  • When you copy a formula down to other cells, Excel automatically adjusts the cell references so each row adds its own numbers.

Using SUM to add many cells at once

When you have more than two or three numbers to add, the SUM function is faster and cleaner than typing plus signs between each cell. Type =SUM(A1:A10) to add all the numbers from cell A1 through A10. The colon between the two cell addresses tells Excel to include everything in between.

You can also add cells that aren't next to each other. Type =SUM(A1,A3,A5) to add only those three specific cells, skipping A2 and A4. Use commas to separate the cells or ranges you want to include.

SUM ignores empty cells and text, so if your data has gaps or labels mixed in, SUM still works correctly. This makes it much more reliable than adding by hand or using individual plus signs.

Copying a formula down to other rows

Once you write a formula in one cell, you can copy it down to calculate the same thing for other rows. Click the cell with your formula, then look for the small square in the bottom right corner of the cell. Click and drag that square downward to copy the formula to as many rows as you need.

When you do this, Excel automatically changes the cell references in each row. If your first formula was =A1+B1, the next row becomes =A2+B2, then =A3+B3, and so on. You don't have to rewrite the formula each time — Excel handles the adjustment for you.

You can also select the cell with the formula, copy it (Ctrl+C on Windows, Command+C on Mac), then select the range where you want it to go and paste (Ctrl+V or Command+V). This does the same thing as dragging the corner square.

Adding cells from different sheets

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

If your sheet name has spaces in it, put the name in single quotes: ='Sales Data'!A1+B1. This tells Excel that the whole thing in quotes is the sheet name, not a separate instruction.

You can use SUM across sheets too: =SUM(Sheet1!A1:A10,Sheet2!A1:A10) adds the range A1 through A10 from both sheets together. This is useful when you have the same data structure on multiple sheets and need a total.

Fixing common mistakes

The most common mistake is forgetting the equals sign. If you type A1+B1 without the equals sign at the start, Excel shows you the text "A1+B1" instead of doing the math. Just click the cell, add the equals sign at the beginning, and press Enter again.

Another mistake is using the wrong cell reference. If you meant to add A1 but typed A10 instead, the formula runs fine — it just adds the wrong number. Check that the cell addresses in your formula point to the cells you actually want to add.

If you see #NAME? as the result, you likely misspelled a function name or sheet name. If you see #REF!, the formula is trying to reference a cell or sheet that no longer exists. Both errors are Excel's way of saying the formula can't find what it's looking for.

When to use addition versus other functions

Addition with plus signs or SUM works when you want a total of all the numbers. But Excel has other functions for different jobs. Use AVERAGE to find the middle value of a set of numbers, COUNT to count how many cells have numbers in them, and MAX or MIN to find the largest or smallest number in a range.

If you need to add numbers only if they meet a condition — for example, add sales only from the North region — use SUMIF. Type =SUMIF(C1:C10,"North",D1:D10) to add values in D1 through D10 only where the corresponding cell in C1 through C10 says "North".

For most everyday tasks, SUM is what you'll reach for. The other functions exist for when addition alone doesn't answer your question.

Frequently Asked Questions

Can I add cells that have text and numbers mixed together?

SUM ignores text and only adds the numbers. If a cell contains "100 units", SUM treats it as text and skips it. If you need to extract the number from text, you'll need more advanced functions, but for basic addition, SUM works fine as long as your cells contain only numbers.

What's the difference between =A1+B1 and =SUM(A1:B1)?

Both give the same result when adding just two cells. SUM is cleaner when you have many cells to add because you don't have to type a plus sign between each one. For two or three cells, either works; for ten or more, SUM saves time and is easier to read.

Why did my formula change when I copied it to another cell?

Excel automatically adjusts cell references when you copy a formula. If you want a cell reference to stay the same when you copy, put a dollar sign before the letter and number: =$A$1+B1. Now A1 never changes, but B1 will adjust to B2, B3, and so on as you copy down.

Can I add numbers from a file on my computer that isn't open right now?

Yes, but the other file needs to be open in Excel for the formula to work. If you close that file, the formula breaks. For permanent links between files, you'll need to use more advanced features like external links, which are beyond basic addition but possible in Excel.