How to Add Multiple Cells Together in Excel

The fastest way to add cells in Excel

To add several cells in Excel, type =SUM( followed by the range of cells you want to add, then close with a parenthesis. For example, to add cells A1 through A5, you would type =SUM(A1:A5) and press Enter. Excel will calculate the total and display it in the cell where you typed the formula.

You can also add cells that are not next to each other. Type =SUM(A1,A3,A5) to add only those specific cells, separating each one with a comma. This method works whether the cells are in the same column, the same row, or scattered across your spreadsheet.

The SUM function ignores empty cells and text, so it will only add numbers. If a cell contains text or is blank, Excel skips it and adds only the numeric values in your range.

Key Takeaways

Use =SUM(A1:A5) to add a continuous range of cells, where the colon tells Excel to include everything between the first and last cell.
Use =SUM(A1,A3,A5) with commas to add only specific cells that are not next to each other.
You can combine both methods in one formula, such as =SUM(A1:A5,C1:C3), to add multiple separate ranges at once.
The SUM function automatically ignores empty cells and text values, adding only the numbers it finds.
After you type your formula, press Enter to execute it, and Excel will display the result in that cell.

Adding a continuous range of cells

When the cells you want to add are next to each other in a row or column, use the colon syntax. Click on the cell where you want the result to appear, then type =SUM(. Next, click on the first cell in your range and drag to the last cell, or type the cell addresses separated by a colon.

For example, if you have numbers in cells B2, B3, B4, and B5, click on an empty cell below or to the side and type =SUM(B2:B5). The colon tells Excel to include all cells from B2 to B5. Press Enter, and Excel adds them together instantly.

This method is faster than typing individual cell addresses because you only need to specify the starting and ending points. Excel figures out which cells fall between them and adds them all.

Adding specific cells that are not adjacent

When the cells you need are scattered across your spreadsheet, separate each cell address with a comma instead of a colon. Click on the cell where you want the result, then type =SUM( followed by the first cell address, a comma, the next cell address, and so on.

For instance, if you want to add the values in A2, C5, and E8, type =SUM(A2,C5,E8) and press Enter. Excel adds only those three cells, ignoring everything else on the sheet. You can add as many individual cells as you need this way.

You can also mix ranges and individual cells in the same formula. Type =SUM(A1:A5,C2,E3:E7) to add the range A1 through A5, plus the single cell C2, plus the range E3 through E7. This flexibility lets you build formulas that match exactly what you need to calculate.

Using the AutoSum button for quick calculations

Excel has a built-in button that creates a SUM formula for you automatically. Select the cells you want to add, then look for the AutoSum button in the toolbar — it looks like the Greek letter sigma (Σ). Click it, and Excel inserts a SUM formula in the cell directly below or to the right of your selection.

This method is useful when you have a column or row of numbers and want to add them all at once. Select the range, click AutoSum, and Excel guesses the correct range for you. Most of the time it gets it right, but you can always edit the formula if it includes or excludes the wrong cells.

The AutoSum button saves typing and is especially helpful when you are working with large ranges. It also reduces the chance of accidentally typing the wrong cell addresses.

Editing and copying your SUM formula

After you create a SUM formula, you can change it by clicking on the cell and editing the formula bar at the top of the screen. Click inside the formula bar, add or remove cell addresses, and press Enter to update the result. You can also double-click the cell itself to edit the formula directly in the cell.

To copy a formula to other cells, click on the cell containing your SUM formula and press Ctrl+C (or Cmd+C on Mac). Then select the cells where you want to paste it and press Ctrl+V. Excel automatically adjusts the cell references in each copy, so if you copy =SUM(A1:A5) down one row, it becomes =SUM(A2:A6) in the next row.

This automatic adjustment is called a relative reference and saves time when you need the same calculation in multiple places. If you want the formula to always refer to the same cells no matter where you copy it, add dollar signs: =SUM($A$1:$A$5) creates an absolute reference that does not change when copied.

Common mistakes when adding cells

The most common error is forgetting the equals sign at the beginning. Excel only recognizes it as a formula if you start with =. If you type SUM(A1:A5) without the equals sign, Excel treats it as text and displays it as you typed it instead of calculating the result.

Another mistake is using the wrong separator. In most English-language versions of Excel, use a colon to separate the start and end of a range (A1:A5) and a comma to separate individual cells or ranges (A1,A3,A5). Some versions of Excel in other regions use a semicolon instead of a comma, so check your settings if your formula does not work.

Accidentally including text in your range will not break the formula — SUM simply ignores text values and adds only the numbers. However, if you type text inside the parentheses where a cell address should be, Excel will show an error. Always double-check that you are referencing actual cell addresses, not typing numbers or words directly into the formula.

Adding cells with conditions or criteria

If you need to add cells only when they meet certain conditions, use SUMIF instead of SUM. For example, =SUMIF(A1:A10,">50") adds only the cells in A1 through A10 that contain values greater than 50. The SUMIF function lets you set a rule and add only the cells that match it.

You can also use SUMIFS when you have multiple conditions. Type =SUMIFS(A1:A10,B1:B10,"Yes",C1:C10,">100") to add values in A1 through A10 only when the corresponding cell in B is "Yes" and the corresponding cell in C is greater than 100. This is useful for more complex calculations where simple addition is not enough.

Both SUMIF and SUMIFS follow the same basic structure as SUM: start with an equals sign, type the function name, and put your criteria inside the parentheses. The main difference is that you specify which cells to check and what condition they must meet before Excel adds them.

Frequently Asked Questions

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

Yes. Type the sheet name followed by an exclamation point and the cell address. For example, =SUM(Sheet1!A1:A5,Sheet2!B1:B5) adds cells from two different sheets. If your sheet name has spaces, put it in single quotes: =SUM('Sheet 1'!A1:A5).

What happens if I add cells that contain formulas?

Excel adds the results of those formulas, not the formulas themselves. If cell A1 contains =5+3 and you add it to other cells, Excel uses the value 8 in the calculation. This works seamlessly and is one of the most common ways to build complex spreadsheets.

How do I add cells and display the result in a different cell?

Click on any empty cell where you want the result to appear, then type your SUM formula. The result will show in that cell, and the original cells remain unchanged. You can place your formula anywhere on the sheet, not just next to the cells you are adding.

Can I add cells if some contain negative numbers?

Yes. SUM treats negative numbers as negative values, so they subtract from the total. If you add A1 (which contains 10) and A2 (which contains -5), the result is 5. This is the expected behavior and works correctly in all versions of Excel.

What is the difference between SUM and just typing the formula myself?

There is no difference in the result — =SUM(A1:A5) and =A1+A2+A3+A4+A5 produce the same answer. SUM is faster to type and easier to read, especially with large ranges. It also handles empty cells more gracefully, so it is the standard choice for most situations.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.