How to Sum a Row in Google Sheets: Simple Formula

To sum a row in Google Sheets, put the total in an empty cell and enter =SUM(B2:F2). This example assumes the numbers are in B2:F2 and the total goes in G2; if those cells contain 12, 8, 15, a blank, and 5, the result is 40. The total updates when the numbers in the range change.

You can use this method in Google Sheets in a web browser, on a computer or Chromebook. No add-on is needed. The steps below show how to choose the range, check the result, and copy the total formula to other rows.

What You’ll Need

A Google Sheets spreadsheet you can edit.
The row of numbers you want to add and an empty cell for the total.
For the worked example, values in B2:F2 and an open total cell in G2. Your data can be in different columns; adjust the range to match.

Step-by-Step

Open the spreadsheet and find the row. Open the file in Google Sheets and identify the cells that hold the values to add. Look at the column letters above the data and the row number on its left. For example, if the first value is in B2 and the last is in F2, the range is B2:F2. Include all and only the cells you want in the total.
Choose an empty cell for the answer. Click the cell immediately to the right of the last value when possible. For a row ending in F2, G2 is a convenient place for the total. Keeping the result outside the range prevents the formula from trying to add its own result, which can cause a circular-reference error. If there is already data in the neighboring cell, choose another empty cell and make a note of where you put the total.
Enter the SUM formula. With the values in B2:F2 and the total cell G2 selected, type =SUM(B2:F2). The equal sign tells Sheets to calculate an expression; SUM adds the values in the parentheses. The colon means the range includes every cell from B2 through F2. You can type the formula directly in the cell or in the formula bar above the grid.
Confirm the entry. Press Enter. Google Sheets will calculate the total and leave the selected cell below or beside the result, depending on the sheet layout. If the example values are 12, 8, 15, blank, and 5, the displayed answer should be 40. Click G2 again to check that the formula bar shows the formula rather than a number typed in by hand.
Check that the range is right. Compare the highlighted cells or the formula text with the row you meant to add. Make sure the first and last intended values are included and that the total cell is not part of the range. If your values are in C4:H4, for example, edit the range to match those cells instead of copying the example unchanged. A total that looks plausible can still be wrong if one column was missed.
Copy the formula to other rows if needed. If the same kind of total is needed for several rows, select the cell containing the total. Drag the small blue square at the bottom-right corner of the selection down through the rows that need totals. Sheets adjusts the row references as it fills: a formula for row 2 becomes a formula for row 3, then row 4. Check at least one copied result against its row before relying on the full column.
Save or share the sheet as usual. Google Sheets saves changes automatically when you are online. If you are working offline, wait for the file to sync after reconnecting. If other people use the spreadsheet, make sure they have the access they need and that the total cell is not accidentally overwritten while they edit nearby data.

You can also insert the function from the menu: select the total cell, choose Insert > Function > SUM, then select the cells to add and press Enter. Typing the formula is usually quicker for a simple row, while the menu can help if you are unfamiliar with function names. Google Sheets uses the same basic SUM formula syntax as Excel, but the instructions here refer to the Google Sheets browser interface.

Common Mistakes

Leaving out the first or last cell. A range can be off by one column, especially when there are headings or blank cells between sections. Check the range endpoints against the actual row. A blank cell inside the selected range is okay; it does not make SUM stop at that point.
Including the total cell in the range. If the total sits in G2, do not include G2 in the cells being added. A range that includes its own formula can create a circular dependency rather than a normal answer. Keep the total outside the range, or move it to a cell that is not included.
Using plus signs for a long row and missing a cell. Adding individual cell references manually can work, but it is easy to skip one or leave out a new value later. A continuous range is simpler when the cells are side by side. If the cells are separated, inspect each reference carefully.
Assuming numbers that look numeric are always numbers. Values imported from another file may be stored as text, perhaps because of a leading apostrophe, extra spaces, or an unusual decimal separator. SUM may ignore text in referenced cells. Check whether the values align or format as expected, and inspect a cell’s contents if the result is unexpectedly low.
Expecting hidden rows to be excluded. SUM adds the cells in its range whether rows are hidden manually or filtered out of view. If your goal is to total only visible records, a basic SUM is not the right choice; clarify whether filtered or hidden entries should count before choosing a different method.

Tips

Use a clear label. Put a heading such as Total in the cell above or beside the result. This makes it easier for someone scanning the sheet to distinguish a calculated amount from the row’s original data.
Keep the formula in the sheet. A formula recalculates when source values change; a number pasted as plain text does not. If you copy a total elsewhere, make sure you know whether you want a live formula or a fixed snapshot of the current result.
Use fill for repeated totals, then inspect the references. Dragging the fill handle is useful when each row has the same layout. It is still worth checking a filled formula near the bottom of the data, especially if the table contains blank rows or a different layout partway through.
Make the total easy to spot without changing its value. You can format the result cell with bold text or a border using the toolbar. Formatting changes how the answer looks, not the calculation. Avoid placing a label or decorative text inside the range of cells you intend to add.
Decide how to treat future columns. A formula that ends at F2 will not include a new number entered in G2 or farther to the right. Leave room for planned values, or update the range when you add columns. Keep the result cell separate so expanding the range does not make it part of the calculation.

Troubleshooting

The result is zero or lower than expected: First check that the formula points to the intended row and includes the right columns. Then click a value that may be missing and inspect the formula bar. Imported numbers may be text, and text entries are not added as ordinary numeric values. Remove unwanted spaces or convert the entries into numbers using the spreadsheet’s available editing and formatting tools. Do not assume that applying a number format alone will convert text into numeric data.

The cell displays an error: Check that the formula begins with an equal sign, the range uses a colon between its endpoints, and both parentheses are present. Make sure there is no circular reference: the cell containing the total must not be included among the cells being summed. If the error is a reference error, a row or column included in the formula may have been deleted or moved; edit the range to point to the current data.

The formula appears as text instead of calculating: Select the cell and look for an apostrophe or other character before the equal sign. If the cell is formatted as plain text, change its format to Automatic using Format > Number > Automatic, then re-enter the formula. Press Enter after typing; simply pasting text into a cell may not trigger the calculation if the entry was treated as text.

The total changes after you copy it: That is usually expected. When you fill a formula down, Sheets adjusts relative row references so each total refers to its own row. Click a copied result and confirm that its range matches the values beside it. If you copied a formula sideways or into a differently arranged table, the adjusted columns may not be the ones you intended.

The total includes filtered-out values: A normal SUM includes every cell in its specified range, including rows hidden by a filter. Decide whether the task is to total all records or only the visible ones. If only visible records should count, look for an approach designed for filtered data rather than treating a basic row or column SUM as a visibility-aware calculation.

Frequently Asked Questions

Can I sum a row without typing a formula?
You can select the cells and look at the sum shown in the Sheets status bar, if it is visible, but that does not place a lasting total in the grid. To keep a calculated total in the sheet and have it update, enter a SUM formula in an empty cell.

Can SUM handle blank cells in a row?
Yes. Blank cells within the range do not prevent the other numeric values from being added. You generally do not need to remove empty cells before summing a range.

Will the total update when I change a value?
Yes. A SUM formula recalculates when a referenced value changes. If it does not, check that the value is within the formula’s range and is stored as a number rather than text.

How do I add cells that are not next to each other?
Use SUM with separate cell references or ranges separated by commas inside the parentheses. For a basic row with adjacent cells, a single continuous range is easier to read and less likely to miss a value.

Can I use the same method in Excel?
Yes. Excel also supports the SUM function and the same range style. The formula is the same, but Excel’s menus and interface differ from Google Sheets, so follow the steps for the program you are using.

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.