How To Sum A Row In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to sum a row in Google Sheets.

How To Sum A Row In Google Sheets

Adding up the values in a row is a common operation in Google Sheets spreadsheets.

For example, you may have a row that keeps track of expenses. You will need to get the sum of the whole row to determine the total cost.

Google Sheets makes it easy for users to sum a row with just a few clicks

The SUM function allows the user to input one or more cell ranges as an argument. We can specify a certain row by converting the row number into a cell range format.

For example, if you would like to reference row 2, you may use the cell reference ‘2:2’.

In this tutorial, we’ll show you how to add an entire row in Google Sheets using the SUM function.

How To Find the Sum of a Single Row In Google Sheets

Here’s how to find the sum of a single row in Google Sheets:

In this example, we have a table of monthly financial data that includes values for both profit and revenue.

We want to determine the annual profit based on the given dataset.

Step 1

If you will reference the entire row, it is best to place this cell in a different row from the one you will be summing up.

Step 2

Next, type “=SUM(“ into the Formula Bar.

Step 3

Next, we will need to specify the row that we want to find the sum of. You may either type it manually or by using the cursor to select the row yourself.

We can reference the cell manually by converting the row number to the following format: <row number>:<row_number>. Alternatively, you may click on the row number header of the row you wish to sum up. Your chosen row should now appear highlighted.

Step 4

Hit the Enter key to evaluate the result. Your cell should now show the sum of all numerical values in a row.

Note that the SUM function ignores all non-numeric values.


This guide should be everything you need to know to find the sum of a row in Google Sheets. You may make a copy of this example spreadsheet to test it out on your own.