How to Add Numbers and Formulas in Google Sheets

The simplest way to add in Google Sheets

To add numbers in Google Sheets, you type a formula that starts with an equals sign, then the numbers or cell references you want to add, separated by plus signs. For example, if you want to add 5 and 3, you type =5+3 into a cell and press Enter. If you want to add the values in two cells — say cell A1 and cell B1 — you type =A1+B1.

The most common way to add multiple numbers at once is the SUM function. Instead of typing =A1+A2+A3+A4, you can type =SUM(A1:A4), which adds all the cells from A1 through A4. The colon between the two cell names means "through" — it includes every cell in that range.

When you press Enter, Google Sheets calculates the result and shows it in the cell. If you change any of the numbers in the cells you added, the total updates automatically.

Key Takeaways

Type =5+3 to add specific numbers, or =A1+B1 to add the values in two cells.
Use =SUM(A1:A4) to add a range of cells instead of typing each one with a plus sign.
The colon in A1:A4 means "through" — it includes every cell from the first to the last.
When you change a number in any cell that the formula uses, the total recalculates when ready.
You can add cells across different rows and columns by listing them with commas, like =SUM(A1:A3,C1:C3).

Adding a single row or column of numbers

If you have a list of numbers in one column or row and want to add them all up, the SUM function is the fastest way. Click on the empty cell where you want the total to appear — usually at the bottom of the column or the right end of the row.

Type =SUM(, then click on the first cell in your list and drag down (or across) to the last cell. Google Sheets fills in the range for you. When you release the mouse, type the closing parenthesis ) and press Enter. The total appears in the cell.

For example, if you have numbers in cells A1, A2, A3, and A4, you can click on A1, drag to A4, and Google Sheets shows you =SUM(A1:A4). This is much faster than typing it by hand, especially with a long list.

Adding numbers from different parts of the spreadsheet

Sometimes the numbers you want to add are not next to each other. You might have sales data in column A, expenses in column C, and adjustments in column E. To add cells that are not in one continuous range, use commas to separate them.

Type =SUM(A1:A5,C1:C5,E1:E5) to add all the cells in those three separate ranges. Each range uses a colon, and a comma separates one range from the next. You can add as many ranges as you need this way.

You can also mix individual cells and ranges. For example, =SUM(A1,B2:B5,C10) adds cell A1, the range B2 through B5, and cell C10 all together. Google Sheets treats them all the same — it just adds whatever numbers are in those cells.

Using the plus sign for a few cells

If you only have two or three cells to add, typing them with plus signs is often simpler than using SUM. Type =A1+B1+C1 to add three cells, or =10+20+30 to add three specific numbers.

This method works fine for small lists, but it becomes tedious and error-prone with more than about five cells. If you find yourself typing many plus signs, switch to SUM instead — it is clearer and easier to edit later if you need to change which cells you are adding.

You can also mix numbers and cell references in one formula: =A1+50+B1 adds the value in A1, plus 50, plus the value in B1. Google Sheets treats them all the same.

Copying a formula down or across multiple cells

Once you have written a formula in one cell, you can copy it to other cells and Google Sheets adjusts the cell references automatically. For example, if you write =SUM(A1:A5) in cell B1, then copy that formula to cell B2, it becomes =SUM(A2:A6) — the range shifts down by one row.

To copy a formula, click on the cell that contains it, then click and drag the small square in the bottom-right corner of the cell down or across to the cells where you want the formula to appear. Google Sheets fills in the formula and adjusts the cell references for each row or column.

This is useful when you have a table with numbers in multiple rows or columns and you want to add each row or column separately. Write the formula once, then drag it across or down to fill the rest of the table. Each cell calculates its own total based on the cells in that row or column.

Checking your formula if the result looks wrong

If your total does not look right, click on the cell with the formula and look at the formula bar at the top of the screen — it shows exactly what formula is in that cell. Check that the cell references are correct and that you have included all the cells you meant to add.

A common mistake is typing a cell reference wrong — for example, typing A10 when you meant A1, or using a range that is one cell too short. Another mistake is forgetting to start with an equals sign; if you type SUM(A1:A5) without the equals sign, Google Sheets treats it as text and does not calculate anything.

If you copied a formula and the result changed in an unexpected way, click on the cell and check the formula bar. The cell references may have shifted when you copied it. If you want the formula to always refer to the same cells no matter where you copy it, use dollar signs: =SUM($A$1:$A$5) keeps the range locked to A1 through A5 even when you copy the formula to a different cell.

Adding numbers with conditions

Sometimes you want to add only the numbers that meet a certain condition — for example, adding only the sales over $100, or only the expenses from a certain month. Google Sheets has functions for this, though they are more advanced than basic addition.

The SUMIF function adds cells only if they meet one condition. For example, =SUMIF(A1:A10,">100") adds only the numbers in cells A1 through A10 that are greater than 100. The SUMIFS function lets you add based on multiple conditions at once.

These functions are useful when your spreadsheet has a lot of data and you need to total only part of it. They work the same way as SUM — you type the function name, then the range of cells to check, then the condition you want to match.

Frequently Asked Questions

What is the difference between =A1+B1 and =SUM(A1:B1)?

Both give the same result, but SUM is clearer when you have many cells to add. With just two cells, either works fine. SUM is also easier to edit later — if you need to add more cells, you just change the range instead of retyping the whole formula with plus signs.

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

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

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: =SUM(Sheet2!A1:A5) adds the range A1 through A5 from a sheet named Sheet2. If the sheet name has spaces, put it in single quotes: =SUM('Sales Data'!A1:A5).

What happens if I copy a formula and want it to always use the same cells?

Use dollar signs to lock the cell references. Type =SUM($A$1:$A$5) instead of =SUM(A1:A5). The dollar signs tell Google Sheets to keep those exact cells even when you copy the formula to a different location. You can lock just the column, just the row, or both.

Can I add cells that have text in them?

No. Google Sheets only adds cells that contain numbers. If a cell has text, Google Sheets ignores it and adds only the numbers in the other cells. If all the cells in your formula contain text, the result is 0 or an error.

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.