The simplest way to add in Excel

To add two or more numbers in Excel, type them into separate cells, then use the SUM function. Click the cell where you want the total to appear, type =SUM(, then select the cells you want to add together, and type ). Press Enter, and Excel shows the result.

For example: if the number 5 is in cell A1 and the number 3 is in cell A2, click cell A3, type =SUM(A1:A2), and press Enter. Excel displays 8.

The colon between A1 and A2 tells Excel to add everything in that range. If your numbers are not next to each other, you can add specific cells instead: type =SUM(A1,C1,E1) to add only those three cells, skipping the ones in between.

Key Takeaways

  • The SUM function is the standard way to add numbers in Excel: type =SUM( followed by the cells you want to add, then close with ).
  • Use a colon (A1:A5) to add a range of cells, or separate cells with commas (A1,C1,E1) to add only specific ones.
  • You can add numbers typed directly into the formula instead of cell references: =SUM(5,10,3) adds to 18.
  • The plus sign (+) works for adding two or three numbers, but SUM is faster and clearer when you have many numbers to total.

Using the plus sign for quick addition

If you only need to add two or three numbers, you can use the plus sign instead of SUM. Click the cell where you want the result, type =, then click the first cell, type +, click the second cell, type + again if you have a third, and press Enter.

For example: =A1+B1+C1 adds the values in those three cells. This method works fine for a handful of numbers, but if you have ten or twenty numbers to add, SUM is much faster because you do not have to type a plus sign between each one.

Adding numbers you type directly into the formula

You do not have to put numbers in cells first. You can type them straight into the formula. Click the cell where you want the total, type =SUM(5,10,15), and press Enter. Excel adds them and shows 30.

You can also mix cell references and typed numbers in the same formula: =SUM(A1,10,B2,5) adds the value in A1, plus 10, plus the value in B2, plus 5. This is useful when you have some numbers already in cells and need to add a fixed amount to them.

Adding a column or row of numbers

When you have a long list of numbers in one column or row, SUM with a range is the fastest method. If your numbers run from A1 down to A20, click the cell below the last number (A21), type =SUM(A1:A20), and press Enter.

Excel also has a shortcut: click the cell where you want the total, then press Alt + = on Windows or Cmd + Shift + T on Mac. Excel looks at the numbers above or to the left of that cell and creates a SUM formula for you automatically. This is called AutoSum.

AutoSum does not always pick the exact range you want, so check the highlighted cells before you press Enter. If it selected too many or too few, click and drag to adjust the range, then press Enter.

Fixing common addition mistakes

If your formula shows an error or the wrong number, check these common problems. Make sure you started with an equals sign (=) — without it, Excel treats your entry as text, not a calculation. Check that you closed the parenthesis: =SUM(A1:A5) works, but =SUM(A1:A5 without the closing parenthesis causes an error.

If the result looks too high or too low, click the cell with the formula and look at the formula bar at the top of the screen. It shows exactly which cells the formula is adding. If you see cells you did not mean to include, click in the formula bar, adjust the range, and press Enter again.

If a cell shows #VALUE! or #REF!, the formula is trying to add text or a cell that does not exist. Check that all the cells you listed actually contain numbers, not words or empty space.

Adding with conditions (summing only certain rows)

Sometimes you need to add numbers only if they meet a condition — for example, adding sales only from a certain region or only amounts over $100. For this, use SUMIF instead of SUM.

The formula looks like this: =SUMIF(range_to_check, condition, range_to_add). If column A holds region names and column B holds sales amounts, and you want to add sales only from the "North" region, type =SUMIF(A:A,"North",B:B). Excel adds only the numbers in column B where the matching cell in column A says "North".

SUMIF is more complex than basic SUM, so start with simple addition first. Once you are comfortable with SUM, SUMIF becomes useful for filtering your totals.

Frequently Asked Questions

What is the difference between SUM and just typing numbers with plus signs?

Both work, but SUM is faster and clearer when you have many numbers. With plus signs, you type =A1+A2+A3+A4+A5. With SUM, you type =SUM(A1:A5). For five numbers, the difference is small. For fifty numbers, SUM saves time and is easier to read later.

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

Yes. Type the sheet name, then an exclamation point, then the cell: =SUM(Sheet1!A1,Sheet2!B5) adds the value in A1 from Sheet1 and B5 from Sheet2. If the sheet name has a space, put it in single quotes: =SUM('Sales Data'!A1).

What does it mean when my formula shows a number in the cell but the formula bar shows something different?

The formula bar shows what the cell actually contains (the formula), and the cell itself shows the result. This is normal. If you want to see the formula instead of the result, press Ctrl + ` on Windows or Ctrl + ` on Mac (the backtick key, usually near the 1 key). Press it again to switch back to showing results.

Can I add cells that are not next to each other?

Yes, separate them with commas: =SUM(A1,A5,A10) adds only those three cells, skipping A2 through A4 and A6 through A9. You can also mix ranges and individual cells: =SUM(A1:A5,C1,D1:D10) adds the range A1 to A5, plus C1, plus the range D1 to D10.