The basic way to add in Google Sheets

To add numbers in Google Sheets, you use the SUM function. Click the cell where you want the total to appear, type =SUM(, then select the cells you want to add together, and close with ). For example, if you want to add the numbers in cells A1, A2, and A3, you would type =SUM(A1:A3) and press Enter.

You can also add just two cells by typing =A1+A2 directly into a cell. This works for any number of cells — =A1+A2+A3+A4 will add all four. The SUM function is faster when you have many cells to add, because you only need to type the range once instead of typing each cell name.

Google Sheets calculates the result instantly and displays it in the cell. If you change any of the numbers you added, the total updates automatically.

Key Takeaways

  • Use =SUM(A1:A3) to add a range of cells, where A1:A3 means all cells from A1 to A3.
  • Use =A1+A2 to add specific cells that are not next to each other.
  • Google Sheets updates the total automatically whenever you change any of the numbers being added.
  • You can add cells in a column, a row, or a mix of both by adjusting the cell references in your formula.
  • The formula bar at the top shows what formula is in each cell, so you can check your work.

Adding a column of numbers

To add an entire column of numbers, click the cell below the last number and type =SUM(A:A) to add all numbers in column A. You can replace A with any column letter. This works even if you add more numbers to the column later — the total will update on its own.

If you only want to add part of a column, specify the range: =SUM(A1:A10) adds only cells A1 through A10. This is useful when your spreadsheet has headers or notes at the top that you do not want to include in the total.

Adding a row of numbers

To add numbers across a row, click the cell to the right of the last number and type =SUM(A1:E1) to add cells A1 through E1. Replace the letters and numbers with the actual range you want to add.

You can also use =SUM(1:1) to add every number in row 1, though this is less common because rows usually contain different types of information rather than all numbers meant to be totaled together.

Adding non-adjacent cells

If the cells you want to add are not next to each other, separate them with a comma. For example, =SUM(A1,A3,A5) adds only cells A1, A3, and A5, skipping A2 and A4. You can mix columns and rows this way: =SUM(A1,C2,E3) works fine.

You can also combine ranges and individual cells: =SUM(A1:A5,C1:C5) adds all cells from A1 to A5 and all cells from C1 to C5 in one formula. This is useful when you have data organized in separate sections of your spreadsheet.

Using AutoSum to add quickly

Google Sheets has a shortcut called AutoSum. Select the cells you want to add (or click the cell where you want the total), then click the Σ (sigma) button in the toolbar. Google Sheets will automatically create a SUM formula for you.

AutoSum usually guesses correctly which cells to add based on what you have selected, but always check the formula bar to make sure it picked the right range before you press Enter. If it guessed wrong, you can edit the formula directly in the cell or in the formula bar.

Fixing common addition mistakes

If your total shows as #ERROR! or #VALUE!, the formula has a problem. Check that you used a colon (:) between the first and last cell in a range, not a dash or comma. Also make sure the cells you are adding actually contain numbers, not text that looks like numbers.

If the total seems wrong, click on the cell with the formula and look at the formula bar to see exactly what you typed. A common mistake is including a cell with text or a header by accident. You can also click the cell and press F2 to edit the formula directly in the cell, which highlights the range in color so you can see what is being added.

Adding with conditions

If you want to add only numbers that meet a certain condition — for example, only numbers greater than 100 — use SUMIF instead of SUM. The formula looks like =SUMIF(A1:A10,">100"), which adds only the numbers in A1 through A10 that are greater than 100.

You can also use SUMIF to add numbers in one column based on what is in another column. For example, =SUMIF(B1:B10,"Paid",A1:A10) adds all numbers in column A where the matching cell in column B says "Paid". This is useful for totaling sales by status or expenses by category.

Frequently Asked Questions

Can I add cells from different sheets?

Yes. Type the sheet name, then an exclamation mark, then the cell reference: =SUM(Sheet2!A1:A10) adds cells A1 through A10 from a sheet named Sheet2. If your sheet name has spaces, put it in single quotes: =SUM('My Sheet'!A1:A10).

What if I want to add numbers but also show them in a specific format?

Use SUM as normal, then format the cell. Right-click the cell, select Format cells, and choose Number, Currency, Percentage, or another format. The formula stays the same — only how the result displays changes.

Does the order of cells matter in a SUM formula?

No. =SUM(A1:A10) and =SUM(A10:A1) give the same result. Google Sheets always adds all the cells in the range regardless of the order you type them.

Can I add cells and also add a fixed number to the total?

Yes. Type =SUM(A1:A10)+50 to add cells A1 through A10 and then add 50 to the result. You can also subtract, multiply, or divide: =SUM(A1:A10)*2 doubles the total.

What happens if I delete a number from a cell that is part of my SUM formula?

The total updates automatically. If you clear the cell completely, it is treated as zero. If you want to undo the deletion, press Ctrl+Z (or Cmd+Z on Mac) right away.