The basic addition formula in Google Sheets

To add numbers in Google Sheets, you type an equals sign, then the word SUM, then the cells you want to add in parentheses. For example, if you want to add the numbers in cells A1 and A2, you type =SUM(A1:A2) and press Enter. Google Sheets will show you the total.

The colon between A1 and A2 tells Google Sheets to add everything from A1 through A2. If you want to add A1, A2, and A3, you write =SUM(A1:A3). If the cells are not next to each other — say you want A1 plus A5 but not A2, A3, or A4 — you use a comma instead: =SUM(A1,A5).

You can also add two cells with a plus sign: =A1+A2. Both methods work. SUM is faster when you have many cells to add, and the plus sign is clearer when you are adding just two or three.

Key Takeaways

  • Type =SUM(A1:A3) to add cells A1 through A3, or =A1+A2 to add just two cells.
  • Use a colon (A1:A3) to add a range of cells next to each other, and a comma (A1,A5) to add cells that are not next to each other.
  • Press Enter after you type the formula, and Google Sheets will show the total in that cell.
  • You can add numbers in a row, a column, or a mix of both by changing which cells you list in the formula.

Adding a row or column of numbers

If you have a column of numbers — say, expenses in cells A1 through A10 — you can add them all at once with =SUM(A1:A10). Click on the cell where you want the total to appear (usually below the last number), type the formula, and press Enter.

The same works for a row. If you have numbers across cells B1, C1, D1, and E1, you type =SUM(B1:E1) in the cell to the right (F1) and press Enter. Google Sheets adds all four numbers and shows the result.

Adding numbers from different parts of the sheet

Sometimes the numbers you want to add are scattered across the sheet. You might have sales totals in one section and returns in another. Use a comma to separate the ranges: =SUM(A1:A5,C1:C5) adds cells A1 through A5 and also C1 through C5, skipping column B entirely.

You can also mix single cells and ranges. =SUM(A1,B5:B10,D3) adds cell A1, then cells B5 through B10, then cell D3. Google Sheets will add all of them together.

Fixing common addition mistakes

If your formula shows an error or the wrong number, check these things first. Make sure you typed the equals sign at the start — without it, Google Sheets treats what you typed as text, not a formula. Check that your cell references are correct: A1 is not the same as a1, and Google Sheets is case-sensitive for column letters.

If you see #VALUE! or #ERROR!, you may have included a cell that contains text instead of a number. For example, if cell A1 says "Expenses" and you try to add it with numbers, Google Sheets will not know what to do. Move the text to a different cell or remove it from the formula.

If the total looks too high or too low, double-check that you included the right range. A common mistake is typing A1:A5 when you meant A1:A10, or forgetting to include a cell that should be in the sum.

Using AutoSum to add faster

Google Sheets has a shortcut called AutoSum that guesses which cells you want to add. Click on the cell where you want the total, then press Ctrl+Shift+Plus (on Windows) or Cmd+Shift+Plus (on Mac). Google Sheets will look at the cells above or to the left and suggest a SUM formula.

Most of the time, AutoSum gets it right. If it does not, you can edit the formula by clicking on the cell and changing the range. This is faster than typing the whole formula from scratch, especially if you have a long column of numbers to add.

Adding numbers that change

One reason to use a formula instead of typing the total yourself is that the formula updates automatically. If you have =SUM(A1:A5) in cell A6, and then you change the number in A3, the total in A6 updates right away. You do not have to recalculate anything.

This is useful for budgets, expense tracking, or any sheet where the numbers change over time. Set up the formula once, and it will always show the correct total, no matter what numbers you put in the cells.

Frequently Asked Questions

Can I add cells from a different sheet in the same spreadsheet?

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

What if I want to add only cells that meet a certain condition?

Use SUMIF instead of SUM. For example, =SUMIF(A1:A10,">100") adds only the numbers in A1 through A10 that are greater than 100. This is useful when you want a total of only certain items, like expenses over a certain amount.

Can I add numbers that are formatted as text?

Usually not. If a cell looks like a number but is actually stored as text, SUM will ignore it. You can check by clicking the cell — if it is left-aligned instead of right-aligned, it is probably text. Convert it to a number by clicking the cell, then going to Format > Number > Number in the menu.

What happens if I delete a number that is part of a formula?

The formula updates automatically. If you have =SUM(A1:A5) and you delete the number in A3, the total will be recalculated without A3. The formula itself stays the same — it still says A1:A5 — but the result changes because one of those cells is now empty.