How to Put SUM in Google Sheets

To add numbers in Google Sheets, click the cell where you want the total, type =SUM(B2:B6), and press Enter; replace B2:B6 with the cells you want to add. You can also select a range and use the Functions menu to insert SUM. The steps below are for Google Sheets in a web browser and explain how to check the result and fix common problems.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A range of cells containing the numbers you want to total. The cells do not need to be beside each other, but knowing their column letters and row numbers makes it easier to select them accurately.
An empty cell for the result. You can put the total in the same column as the data, below the values, or somewhere else in the sheet.

Step-by-Step

Identify the values to add. Look at the column letters along the top and the row numbers at the left of the sheet. For example, if the amounts are in column B, rows 2 through 6, the range is B2:B6. A colon means the range includes every cell between its first and last address. Check that the range includes all intended values and does not include a heading or an existing total.
Choose the destination cell. Click a blank cell where you want the result to appear. If the numbers are in B2:B6, you might put the total in B7. If you put the total in a cell within the range being summed, the formula can refer to itself and cause a circular dependency, so use a cell outside the range.
Enter the SUM formula. In the example layout, the values to add are in B2:B6 and the result will go in B7. Type =SUM(B2:B6) into B7 and press Enter. The equal sign tells Sheets that the entry is a formula. SUM is the function that adds the cells inside the parentheses, and the colon specifies the continuous range.
Check the displayed total. In this example, if B2 through B6 contain 12, 8, 15, 5, and 10, the formula in B7 returns 50. Compare the displayed result with the values you intended to include. You can select B7 and look at the formula bar above the grid to confirm that the formula points to the correct range.
Insert SUM from the menu if you prefer. Select the blank result cell, then choose Insert > Function > SUM. Sheets inserts a SUM formula for you. It may suggest a range based on nearby data; inspect the highlighted cells or the formula before pressing Enter, and edit the range if the suggestion is incomplete or includes unwanted cells. You can also use the Functions button on the toolbar, marked with a sigma symbol, and choose SUM.
Select the range with your mouse. You do not have to type every cell address. Click the destination cell and type =SUM(, then drag across the cells you want to add. Sheets places the selected range into the formula. Type a closing parenthesis if needed, then press Enter. For the example data in B2:B6, the completed formula in B7 is =SUM(B2:B6). Make sure the selection outline covers the first and last intended cells.
Add separate ranges when the values are not together. SUM can take more than one range, with a comma separating the ranges. In a layout where the first group of amounts is in B2:B4 and the second group is in D2:D4, put the result in F2 and enter =SUM(B2:B4,D2:D4). This adds the two groups without including the cells between them. Check each range separately so you do not accidentally omit a row or include an unrelated number.
Add individual cells when needed. You can also supply separate cell references rather than continuous ranges. With amounts in B2, B5, and B8 and the result in B10, enter =SUM(B2,B5,B8) in B10. This is useful for a few scattered values. For a long list of separated cells, arranging the values into one range or several compact ranges is usually easier to read and maintain.
Sum a column or row when new entries will be added. If amounts are in column B and you want the total in D1, enter =SUM(B:B) in D1. This includes numeric entries throughout column B, including ones added later. Do not place this formula in column B, because the full-column range would include the formula cell itself. For a row, with values across C3:G3 and the result in H3, enter =SUM(C3:G3) in H3.
Use a bounded range for a cleaner total. If you know the data will occupy rows 2 through 100, summing B2:B100 makes the scope obvious and avoids including unrelated values farther down the column. In a layout with amounts in B2:B100 and a result in B101, enter =SUM(B2:B100) in B101. You can extend the range later by editing the formula if the list grows beyond row 100.
Copy a SUM formula to another row or column when appropriate. If each row has its own values, write the formula for the first row, then use the small square at the lower-right corner of the selected cell to drag the formula down. For example, with each row’s amounts in C2:E2 and the row total in F2, enter =SUM(C2:E2) in F2, then drag the fill handle down. Sheets adjusts the row references for the copied formulas. Review a few resulting totals to confirm each one uses the matching row.
Update the source values and verify recalculation. Change a number in the selected range and check that the total updates. SUM recalculates when the referenced values change, so you normally do not need to re-enter it. If you paste additional values outside a bounded range, remember that they will not be included until you expand the range or use an appropriate full-column reference.

Common Mistakes

Using the wrong range: A formula can be syntactically correct but still give a wrong total if it starts one row too low, stops too early, or includes an unwanted cell. Select the result cell and inspect the colored range in the formula bar. Check the first and last included rows against the source data.

Putting the total inside the range: A formula such as a sum of B2:B7 placed in B7 tries to include its own result. Sheets may report a circular dependency instead of a total. Put the result below or beside the source range, or shorten the range so it excludes the destination cell.

Forgetting the equal sign or parentheses: A formula must begin with an equal sign, and the function’s arguments must be inside parentheses. If you type SUM(B2:B6) without the leading equal sign, Sheets may treat the entry as text rather than calculate it. If the formula shows as text, edit the cell and check for an apostrophe or a cell format that is forcing text.

Expecting numbers stored as text to behave like numbers: Imported data may look numeric but be stored as text, especially if it contains spaces, currency symbols typed into the cell, or an apostrophe at the start. SUM ignores text entries in a referenced range. Check whether the values are aligned or formatted unexpectedly, and correct the source data or convert it to numeric values before relying on the total.

Mixing up separators: When you list separate arguments, use commas in the examples above. Google Sheets’ formula separators can depend on the spreadsheet’s locale, so some locales use semicolons instead. If a formula with multiple arguments is rejected, check File > Settings for the spreadsheet locale. A single continuous range such as B2:B6 does not need an argument separator.

Tips

Give the result a clear label, such as Total, in the neighboring cell. A label makes the purpose of the number easier to understand when someone else opens the sheet, and it helps distinguish a calculated result from another amount. Keep labels outside the range being summed so they do not interrupt the data or confuse later edits.

For lists that grow regularly, leave room for new rows or choose a full-column formula placed outside the source column. A bounded range is easier to audit, while a full-column range automatically includes future entries. Consider how the sheet is organized before choosing: a whole-column sum can also include numbers in notes, subtotals, or unrelated sections lower in that same column.

Use one SUM formula per category when you need separate subtotals. For instance, you might total one department’s values in one cell and another department’s values in a different cell, then make a separate grand total. This makes the calculations easier to review than one complicated formula, especially when several groups are involved.

Format the result to make it readable, but keep formatting separate from the calculation. Select the total cell and use the toolbar’s number-format controls to display a number, currency, or percentage as appropriate. A currency format changes how a numeric value is displayed, not the amount SUM calculates. Avoid typing currency symbols into the number itself when you can apply a format instead.

If you are collaborating, check that the formula cell has not been overwritten by a pasted value. Selecting it should show the formula in the formula bar. You can also add a note or label explaining which rows the total covers. Clear documentation is especially helpful when a spreadsheet has several blocks of data or when another person will add rows later.

In Microsoft Excel, the basic SUM formula and the idea of selecting a range are the same. The directions here use Google Sheets menus and browser controls; if you open the file in Excel, its ribbon and menu labels may differ. Google Sheets is available in a browser, and changes are typically saved to the spreadsheet in your Google Drive.

Troubleshooting

The cell displays the formula instead of a number. First, make sure the entry starts with an equal sign and that the cell does not contain a leading apostrophe. If the cell was formatted as plain text before you typed the formula, change its format to Automatic, then edit the entry and press Enter again. Simply changing the format may not convert an existing text entry until you re-enter it.

The result is zero or lower than expected. Check whether the source cells contain real numeric values rather than numbers stored as text. Then inspect the formula range for missing rows. If the data was pasted from another app, remove stray spaces or text characters and convert the entries to numbers. Also check whether the values are in another column from the one named in the formula.

Sheets reports a circular dependency. This usually means that the result cell is included in the range it is adding, either directly or through another formula. Move the result outside the summed range or edit the reference so it excludes the result cell. For example, a total in B7 should not sum B2:B7; use only the source rows that contain the individual amounts.

The formula is rejected as a syntax error. Confirm that the function name is SUM, the parentheses are balanced, and the cell references use a colon for a continuous range. For several separate arguments, check the locale’s separator setting; a semicolon may be required instead of a comma in some spreadsheet locales. Avoid adding extra punctuation or quotation marks around cell references.

The total does not include newly added rows. A bounded range only includes the addresses written in the formula. If the formula sums B2:B20 and a new value is entered in B21, edit the range to include B21 or choose a suitable full-column range. Before expanding the range, make sure it will not include the result cell or unrelated data.

The total changes unexpectedly after sorting or inserting rows. Check the formula again and confirm that its references still cover the intended data. Sorting normally moves cell contents together, but inserted rows, moved data, or edits to the sheet layout can affect what a range includes. For shared or frequently reorganized sheets, keep a clear header row and avoid placing notes or unrelated numbers in the data column.

Frequently Asked Questions

Can I use SUM without typing the whole formula?
Yes. Select the destination cell and choose Insert > Function > SUM, or use the toolbar’s Functions button and select SUM. Review the suggested range before confirming, since Sheets may not guess the exact cells you want.

Does SUM add blank cells?
Blank cells within a referenced range do not change the total. SUM adds numeric values it finds in the range and ignores blank cells and text entries. If a cell that looks like a number is ignored, check whether it is stored as text.

Can SUM add numbers in different parts of the sheet?
Yes. Include each range or cell as an argument, separated by the separator used by your spreadsheet locale. For a few scattered values this is convenient; for many values, consider arranging them in a single continuous range so the formula is simpler to check.

Will the total update when I change a number?
Yes. A SUM formula updates when a value in its referenced range changes. It will not include a new value entered outside that range unless you expand the reference or use a range that already covers the new location.

Can I add an entire column?
Yes, a full-column reference can total numeric values throughout a column and include future entries. Place the result in a different column so the formula does not include itself, and be aware that unrelated numbers anywhere in the source column will also be counted.

Is SUM different in Excel?
The basic SUM function works similarly in Excel and Google Sheets. This guide describes the Google Sheets browser interface; Excel uses different menus and ribbon controls, but a straightforward range formula such as a SUM of B2:B6 follows the same basic pattern.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.