How to Sum only selected Rows in Google Sheets

There can be scenarios where you want to only Sum up only some selected values in a row. Here we have to enter the exact cell locations of the values you want to include and add them to the SUM Function.

Step 1: Select a Cell and Click on Function (Σ) from the toolbar

Select the cell where you want to add the Value of the Sum. Now, on the top toolbar find the “Σ” symbol and click on it.

Step 2: Select the SUM Function

From the dropdown that is opened below “Σ” symbol, click on the “SUM” function.

Step 3: Select the Cells to be Added

After clicking on the SUM function, a blank SUM() will appear and it requires the select the cells. Inside the brackets () select the cells which you desire to sum up. You can manually select the cell locations or just click on the multiple cells while Pressing the “CTRL” key, it will select the cells.

Step 4: Press Enter

Now the sum value of the Selected cells will be calculated and displayed as an output.

How to sum up rows in Google Sheets : Easiest Methods

Method 1: Click the cell > select SUM in the Functions menu > select the cells to be added

Method 2: Select an empty cell > enter =SUM( and select the cells. Close with ) > Press Enter

Google Sheets is a tool part of the collaborative Google Suite that works on the Cloud. This is a data organization and analysis tool that Google provides and it needs no payment or installation, You have to sign up with your Google account and edit documents.

Mathematical functions and shortcuts are some of the most important and valuable parts of Google Sheets. You’ll frequently need to add up rows of numbers when managing money, monitoring sales, or working on any data-driven project. Have you ever tried to sum rows in Google Sheets? You might be familiar with how to sum cells in Microsoft Excel. The procedure is comparable and straightforward. In this article, we’ll see how to add rows in Google Sheets.