The basic way to add in Excel

To add numbers in Excel, you type a formula that starts with an equals sign, followed by the numbers or cell references you want to add, separated by plus signs. For example, if you want to add 5 and 3, you type =5+3 into a cell and press Enter. Excel shows the result, 8.

Most of the time you will not type numbers directly. Instead, you will add the contents of cells. If the number 5 is in cell A1 and the number 3 is in cell B1, you type =A1+B1 into another cell, and Excel adds them together. When you change the number in A1 or B1, the result updates automatically.

You can add as many cells as you need in one formula. The formula =A1+A2+A3+A4 adds the contents of four cells in a row. For longer lists, the SUM function is faster and clearer.

Key Takeaways

  • All formulas in Excel start with an equals sign, followed by the operation you want to perform.
  • You can add individual numbers with plus signs, or reference cells by their letter and row number.
  • The SUM function adds a range of cells in one step, such as =SUM(A1:A10) to add cells A1 through A10.
  • When you change a number in a cell that a formula references, the result updates right away.
  • You can add cells across different sheets by typing the sheet name before the cell reference, like =Sheet2!A1+A1.

Using the SUM function for longer lists

When you have many numbers to add, typing each cell reference separated by plus signs becomes tedious and error-prone. The SUM function does this work in one step. The syntax is =SUM(start:end), where start and end are the first and last cells in the range you want to add.

For example, if you have numbers in cells A1 through A10, you type =SUM(A1:A10) and Excel adds all ten cells. The colon between A1 and A10 tells Excel to include every cell in that range. You can use SUM for rows as well: =SUM(A1:J1) adds all cells from A1 to J1 in the same row.

SUM also works with non-contiguous cells — cells that are not next to each other. The formula =SUM(A1,A3,A5) adds only cells A1, A3, and A5, skipping A2 and A4. Use commas to separate the individual cells or ranges you want to include.

Adding cells from different sheets

Excel workbooks often contain multiple sheets. To add a cell from a different sheet, include the sheet name before the cell reference, separated by an exclamation point. The formula =Sheet2!A1+A1 adds the value in cell A1 of Sheet2 to the value in cell A1 of the current sheet.

If the sheet name contains a space, you must wrap it in single quotes. For example, ='Sales Data'!A1+A1 adds a cell from a sheet named "Sales Data". You can also use SUM across sheets: =SUM(Sheet1!A1:A10,Sheet2!A1:A10) adds the range A1:A10 from both Sheet1 and Sheet2.

Fixing common addition mistakes

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

Another mistake is using the wrong cell reference. If you copy a formula down a column, Excel adjusts the cell references automatically. For example, if you type =A1+B1 in row 1 and copy it to row 2, Excel changes it to =A2+B2. This is usually what you want, but if you need a cell reference to stay the same when you copy, add dollar signs: =$A$1+B1 keeps A1 fixed while B1 changes to B2, B3, and so on.

If a formula shows #VALUE! error, one of the cells contains text instead of a number. Check that all cells in your formula contain numbers or are empty. If a formula shows #REF! error, you may have deleted a cell that the formula references.

Adding with conditions using SUMIF

Sometimes you need to add numbers only if they meet a certain condition. The SUMIF function does this. The syntax is =SUMIF(range, criteria, sum_range). The range is the cells to check, criteria is the condition, and sum_range is the cells to add.

For example, if column A contains product names and column B contains sales amounts, the formula =SUMIF(A:A,"Apples",B:B) adds all sales amounts in column B where the product in column A is "Apples". You can also use comparison operators: =SUMIF(B:B,">100",B:B) adds all values in column B that are greater than 100.

Displaying the sum in a cell

Once you have written your formula, press Enter to execute it. Excel calculates the result and displays it in the cell where you typed the formula. The cell now shows the sum, not the formula itself. To see the formula again, click the cell and look at the formula bar at the top of the screen.

If you want to see all formulas in your spreadsheet at once instead of their results, press Ctrl+` (grave accent, the key to the left of 1 on most keyboards). Press it again to return to normal view. This is useful for checking your work or understanding how a spreadsheet was built.

Frequently Asked Questions

Can I add cells if some of them are empty?

Yes. Excel treats empty cells as zero. If you use =SUM(A1:A10) and some cells are empty, Excel adds only the cells that contain numbers. The empty cells do not cause an error.

What happens if I add a cell that contains text?

If any cell in your formula contains text, Excel shows a #VALUE! error. Check each cell to make sure it holds a number. If you need to add only the numeric cells and ignore text, use SUMIF or filter your data first.

How do I add a column of numbers and put the result at the bottom?

Click the cell below the last number in the column. Type =SUM(A1:A10), replacing A1:A10 with the actual range of your data. Press Enter. Excel calculates the sum and displays it in that cell.

Can I add numbers from cells in different workbooks?

Yes, but the other workbook must be open. The formula includes the workbook name in brackets, like =[Budget.xlsx]Sheet1!A1+A1. If you close the other workbook, the formula may show an error or a cached value until you open it again.

What is the difference between SUM and just using plus signs?

They produce the same result, but SUM is clearer and faster for many cells. =SUM(A1:A100) is easier to read and write than =A1+A2+A3+...+A100. SUM also handles empty cells and text more gracefully, and it is easier to edit if you need to change the range.