The simplest way to add numbers 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, typing =5+3 in any cell and pressing Enter gives you 8. If your numbers are already in cells — say A1 contains 100 and B1 contains 50 — type =A1+B1 instead, and Excel shows 150.

The reason to use cell references instead of typing numbers directly is that Excel updates automatically when you change a number. If you type =A1+B1 and later change what's in A1, the total recalculates when ready. If you had typed =100+50, you'd have to edit the formula by hand.

You can add as many cells as you want in one formula. =A1+A2+A3+A4 adds four cells in a row. For longer lists, Excel has a faster method called the SUM function, which we'll cover next.

Key Takeaways

  • Type an equals sign followed by cell references separated by plus signs to add numbers: =A1+B1 adds the contents of cells A1 and B1.
  • Use the SUM function for adding many cells at once: =SUM(A1:A10) adds all cells from A1 through A10 in one formula.
  • Excel recalculates totals automatically when you change any number in the cells you're adding, so you don't have to edit the formula.
  • You can add cells that aren't next to each other by typing their references separated by commas: =SUM(A1,A5,A10) adds only those three cells.

Using SUM to add many cells at once

When you need to add more than a few cells, the SUM function is faster than typing plus signs. Instead of =A1+A2+A3+A4+A5, you write =SUM(A1:A5). The colon means "through," so this adds all five cells in one step.

To use SUM, type the equals sign, then the word SUM, then open a parenthesis, then the range of cells you want to add (using a colon between the first and last cell), then close the parenthesis. Press Enter and Excel shows the total.

SUM also works with cells that aren't in a row or column next to each other. If you want to add A1, A5, and A10 but skip the cells in between, type =SUM(A1,A5,A10) with commas separating each cell reference. This is much faster than typing =A1+A5+A10.

Adding a column or row of numbers

A common task is adding up an entire column of numbers — say, a list of monthly sales in column A from row 2 to row 13. Click on the empty cell where you want the total to appear (often the cell right below the last number). Type =SUM(A2:A13) and press Enter.

Excel will show the sum of all those cells. If you later add a new number to that column, you'll need to edit the formula to include it — change A2:A13 to A2:A14, for example. To avoid this, you can use a larger range than you currently need, like =SUM(A2:A100), and Excel will ignore the empty cells.

The same method works for rows. If numbers run across from A1 to E1, type =SUM(A1:E1) to add them all at once.

Copying a formula to other cells

Once you've written a formula in one cell, you can copy it to other cells and Excel adjusts the references automatically. For example, if you write =SUM(A1:A5) in cell B1 and then copy it to cell C1, Excel changes it to =SUM(B1:B5) — it shifts the column reference one column to the right.

To copy a formula, click on the cell containing it, then press Ctrl+C (or Cmd+C on a Mac). Click on the cell where you want the copy, then press Ctrl+V (or Cmd+V). Excel adjusts the cell references to match the new location.

You can also copy a formula down a column. Click the cell with the formula, then drag the small square at the bottom-right corner of the cell down to the cells below. Excel copies the formula and adjusts the row numbers as it goes. This is useful when you have multiple columns of numbers and want to total each one.

When to use absolute references

Sometimes you want a formula to always refer to the same cell, even when you copy it elsewhere. This is called an absolute reference. To make a cell reference absolute, add a dollar sign before the column letter and the row number: $A$1 instead of A1.

For example, if cell A1 contains a tax rate (like 0.08 for 8 percent), and you want to multiply several other cells by that rate, you'd write =B1*$A$1 in one cell, then copy it down. The B1 reference changes to B2, B3, and so on as you copy, but $A$1 always stays the same — it always points to the tax rate.

Without the dollar signs, copying the formula would change both references, and you'd end up multiplying by the wrong cells. Dollar signs lock a reference in place so it doesn't shift when you copy.

Checking your formula for errors

If a formula shows an error like #VALUE! or #REF!, it usually means one of three things: the cell references point to text instead of numbers, a cell you're trying to add has been deleted, or there's a typo in the formula itself.

To find the problem, click on the cell with the error and look at the formula bar at the top of the screen — it shows exactly what you typed. Check that all the cell references exist and contain numbers, not text. If a cell contains a word like "Total" or "N/A", Excel can't add it, and the formula will fail.

If you see #REF!, it usually means a cell you referenced has been deleted. Edit the formula to point to the correct cell instead. If the formula looks correct but still shows an error, try deleting it and typing it again — sometimes a stray character causes problems.

Adding numbers with conditions

Sometimes you want to add only certain numbers based on a condition. For example, you might want to total sales only from January, or add up expenses only above $100. For this, use the SUMIF function.

SUMIF takes three pieces of information: the range of cells to check, the condition to look for, and the range of cells to add. If column A contains months and column B contains sales amounts, and you want to total sales only from January, you'd write =SUMIF(A:A,"January",B:B). This checks every cell in column A, finds the ones that say "January," and adds the matching cells in column B.

You can also use SUMIF with numbers. To add only expenses greater than $100 from a list in column C, write =SUMIF(C:C,">100",C:C). The condition goes in quotes, and you use the same column for both the condition and the sum because you're checking and adding the same data.

Frequently Asked Questions

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

Yes. Type the sheet name, then an exclamation point, then the cell reference. For example, =SUM(Sheet1!A1:A10) adds cells A1 through A10 from Sheet1. If the sheet name has a space in it, put the name in single quotes: =SUM('Sheet 1'!A1:A10).

What's the difference between SUM and just using plus signs?

They give the same result, but SUM is faster to type when you're adding many cells. SUM also ignores empty cells and text, so it's more forgiving if your data isn't perfectly clean. Plus signs require every cell to contain a number.

Why does my formula show the formula itself instead of the answer?

You probably forgot the equals sign at the start. Excel only treats text as a formula if it begins with =. If you typed SUM(A1:A10) without the equals sign, Excel treats it as regular text. Click the cell, add = at the beginning, and press Enter.

Can I add numbers that are formatted as text?

Not directly — Excel sees text and skips it. If a column contains numbers that look like numbers but are actually stored as text (often from imported data), you may need to convert them first. Select the column, go to the Data menu, and look for a "Text to Columns" option that can convert them to real numbers.

What happens if I add a cell that's empty?

Excel treats empty cells as zero, so they don't affect the total. This is why you can write =SUM(A1:A100) even if only the first ten cells have numbers — the rest are ignored and the formula still works correctly.