How to Automatically Add Numbers in Google Sheets

Use SUM to add a column or row of numbers without typing each one

The fastest way to add numbers in Google Sheets is the SUM function. Instead of clicking each cell and adding them manually, you type a formula that does the math for you. SUM adds up whatever range of cells you tell it to, and the total updates automatically if any of those numbers change.

To use SUM, click the cell where you want the total to appear. Type =SUM( followed by the range of cells you want added, then close with ). For example, if you want to add cells A1 through A10, you type =SUM(A1:A10) and press Enter. Google Sheets calculates the total and shows it in that cell.

The colon between two cell names (like A1:A10) tells Google Sheets to include every cell in that range. You can also add specific cells that aren't next to each other by separating them with commas — for instance, =SUM(A1,A3,A5) adds only those three cells and skips A2 and A4.

Key Takeaways

SUM is the standard function for adding numbers, and you type it as =SUM(A1:A10) to add cells A1 through A10.
The total updates automatically whenever any number in the range changes, so you do not have to recalculate by hand.
You can add non-adjacent cells by using commas instead of a colon, like =SUM(A1,A3,A5).
Google Sheets suggests the range to add when you start typing SUM, so you can click to confirm rather than typing the whole range yourself.
Formulas work the same way whether you are adding a column, a row, or a mix of cells from different parts of the sheet.

Let Google Sheets suggest the range for you

When you type =SUM( in a cell, Google Sheets highlights the cells it thinks you want to add. Usually it guesses correctly — if you click a cell below a column of numbers, it highlights that entire column. If you click a cell to the right of a row of numbers, it highlights that row.

You can accept the suggestion by pressing Enter or Tab, or you can click and drag to change which cells are included. If the suggestion is wrong, just click the first cell you want to add, hold Shift, and click the last cell. Google Sheets updates the range in your formula automatically.

This feature saves time because you rarely have to type the full range yourself. For most everyday spreadsheets — adding up a month of expenses, totaling a column of sales figures, summing hours worked — the automatic suggestion is correct on the first try.

Add numbers across multiple sheets in the same file

If your data lives on different sheets within one Google Sheets file, SUM can still add them together. The syntax changes slightly: you include the sheet name before the cell range, separated by an exclamation mark. For example, =SUM(Sheet1!A1:A10,Sheet2!A1:A10) adds the range A1:A10 from both Sheet1 and Sheet2.

This is useful when you organize data by month, by department, or by category on separate sheets and need a grand total. You can also mix single cells and ranges — =SUM(Sheet1!A5,Sheet2!B3:B8) adds one specific cell from Sheet1 and a range from Sheet2.

If you are not sure of the exact sheet name, you can type =SUM( and then click on the sheet tab at the bottom of the screen. Google Sheets automatically inserts the sheet name into your formula, and you just have to select the cells you want to add.

Use SUMIF to add only numbers that meet a condition

Sometimes you do not want to add every number in a range — you only want to add numbers that match a certain condition. SUMIF does this. For example, if you have a column of expenses with a category next to each one, SUMIF can add up only the expenses marked "Office Supplies" or only those over $50.

The formula structure is =SUMIF(range, criteria, sum_range). The first part (range) is where Google Sheets looks for your condition. The second part (criteria) is what you are looking for — it can be a specific word, a number, or a comparison like ">50". The third part (sum_range) is the cells to add up if the condition is true.

For example, if column A contains expense categories and column B contains amounts, =SUMIF(A:A,"Office Supplies",B:B) adds up all amounts in column B where the corresponding cell in column A says "Office Supplies". You can also use =SUMIF(B:B,">50",B:B) to add only expenses greater than $50.

Automatically update totals when you add new rows

If you use SUM with a specific range like =SUM(A1:A10), adding a new number in row 11 will not be included in the total. To make sure new rows are always included, use the entire column instead: =SUM(A:A) adds every number in column A, no matter how many rows you add later.

The downside is that SUM(A:A) will include header text and any other non-numeric data in that column, which Google Sheets ignores anyway. If you have a header row and want to exclude it, you can use a large range that covers your current data and any rows you expect to add — for instance, =SUM(A2:A1000) starts at row 2 (skipping the header) and goes to row 1000, giving you plenty of room for growth.

Another option is to use SUMIF with a condition that only counts numbers, not text. This way, new rows with numbers are automatically included, but headers and labels are ignored.

Copy formulas down to calculate subtotals for each row

If you have a spreadsheet where each row represents a transaction or item with multiple quantities or prices, you can create a formula in one cell and copy it down to every row. For example, if column A has quantity and column B has unit price, you can type =A1*B1 in cell C1 to calculate the total for that row.

Click cell C1, then drag the small square in the bottom-right corner of the cell down to C10 (or however many rows you have). Google Sheets copies the formula to each row and automatically adjusts the cell references — C2 becomes =A2*B2, C3 becomes =A3*B3, and so on. You can then use SUM to add up all the subtotals in column C.

This approach works for any formula, not just multiplication. You can copy SUM formulas, SUMIF formulas, or any other calculation down a column, and Google Sheets adjusts the references automatically. This is one of the biggest time-savers in spreadsheet work — once you set up the formula correctly in the first row, the rest of the column fills itself.

Frequently Asked Questions

What is the difference between SUM and SUMIF?

SUM adds all numbers in a range. SUMIF adds only the numbers that meet a condition you set. Use SUM when you want a total of everything; use SUMIF when you want a total of only certain rows — for example, only sales from a specific region or only expenses above a certain amount.

Can I use SUM to add cells from different sheets?

Yes. Type the sheet name, then an exclamation mark, then the cell range: =SUM(Sheet1!A1:A10,Sheet2!A1:A10). You can add ranges from as many sheets as you need, separated by commas.

Why does my SUM formula show an error?

The most common cause is a typo in the formula or a cell reference that does not exist. Check that your parentheses are closed, that the colon between cell names is correct, and that you are not including text or empty cells that should not be there. Google Sheets also shows an error if you try to add cells that contain text instead of numbers.

Do I have to update the formula if I add new data?

Not if you use the entire column — =SUM(A:A) includes all rows, even new ones you add later. If you use a specific range like =SUM(A1:A10), you will need to edit the formula to include new rows, or you can use a larger range from the start to leave room for growth.

Can I add numbers only if they are above or below a certain value?

Yes, with SUMIF. Use =SUMIF(A:A,">100",A:A) to add only numbers greater than 100, or =SUMIF(A:A,"<50",A:A) for numbers less than 50. You can also use ">=" or "<=" for greater than or equal to, and less than or equal to.

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.