How to Add Multiple Cells Together in Excel

The quickest way to add cells in Excel

To add multiple cells in Excel, type an equals sign, then the cell addresses separated by plus signs, or use the SUM function. The SUM function is faster when you have many cells to add because you only need to type the range once instead of listing each cell individually.

For example, if you want to add cells A1, A2, and A3, you can type =A1+A2+A3 or =SUM(A1:A3). Both give the same result, but SUM is easier to read and less error-prone when you're working with dozens of cells at once.

Key Takeaways

Use the plus sign method (=A1+A2+A3) when adding a small number of specific cells that are not next to each other.
Use the SUM function (=SUM(A1:A3)) when adding a range of cells in a row or column, because it is faster and clearer.
The colon in A1:A3 means "from A1 through A3", so Excel automatically includes every cell in between.
You can combine both methods in one formula, like =SUM(A1:A3)+B5+B7, to add a range plus individual cells that are far apart.

Using the plus sign for scattered cells

The plus sign method works best when the cells you want to add are spread out across your spreadsheet and not in a neat row or column. Click on an empty cell where you want the total to appear, then type the equals sign to start a formula.

Type the first cell address (like A1), then a plus sign, then the next cell address (like C5), and keep going until you have listed all the cells you need. When you press Enter, Excel calculates the sum and shows the result in that cell. If you click on the cell again later, you will see your formula in the formula bar at the top of the screen.

Using SUM for cells in a row or column

The SUM function is the standard way to add cells that sit next to each other in a line. Click on the empty cell where you want the total, then type =SUM( followed by the first cell address, a colon, the last cell address, and a closing parenthesis.

For example, if you have numbers in cells B2 through B10, type =SUM(B2:B10). The colon tells Excel to include every cell from B2 to B10, so you do not have to type each one. This is much faster than typing =B2+B3+B4+B5+B6+B7+B8+B9+B10.

Adding multiple ranges at once

Sometimes you need to add two or more separate groups of cells. You can put multiple ranges inside one SUM function by separating them with semicolons (on Windows) or commas (on Mac). For example, =SUM(A1:A5;C1:C5) adds all cells in A1 through A5 plus all cells in C1 through C5.

You can also mix ranges and individual cells in the same formula. Type =SUM(A1:A5)+B10+D3 to add the range A1 through A5, plus the single cells B10 and D3. This approach keeps your formula readable even when you are combining different parts of your spreadsheet.

Fixing common mistakes

If your formula shows an error or a wrong number, check that you used the right cell addresses. Click on the cell with the formula and look at the formula bar to see exactly what you typed. A common mistake is typing a comma instead of a colon in the range — =SUM(A1,A5) adds only cells A1 and A5, not everything in between.

Another mistake is forgetting the equals sign at the start. Excel will not treat it as a formula if you type SUM(A1:A5) without the equals sign — it will just show the text you typed. If your cells contain text instead of numbers, SUM will ignore the text cells and add only the numbers, which is usually what you want.

Using AutoSum to add cells faster

Excel has a built-in shortcut called AutoSum that can save you typing. Click on the empty cell below or to the right of 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 will automatically create a SUM formula for the cells above or to the left.

AutoSum usually guesses correctly which cells you want to add, but always check the formula bar to make sure it selected the right range before you press Enter. If it picked the wrong cells, you can click and drag to select the correct range, and Excel will update the formula as you drag.

Frequently Asked Questions

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

Yes. Type the sheet name followed by an exclamation mark and the cell address, like =SUM(Sheet1!A1:A5)+Sheet2!B3. This adds the range A1 through A5 from Sheet1 and the single cell B3 from Sheet2. Make sure the sheet name matches exactly, including capital letters.

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+5 and cell A2 contains =3+2, then =SUM(A1:A2) gives you 15, because A1 equals 10 and A2 equals 5.

Can I add cells if some are empty?

Yes. SUM treats empty cells as zero, so they do not affect your total. This is why SUM is safe to use even if you add extra cells by accident — the empty ones will not change your result.

How do I add cells only if they meet a certain condition?

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

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.