How To Find Range In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to find ranges in Google Sheets.

You can easily find ranges by naming them in Google Sheets. This allows you to easily insert ranges into your formulas and creates a cleaner formula.

Once ready, we’ll get started by utilizing real-world examples to show you how to find the range in Google Sheets.

How To Find Range In Google Sheets

Before we begin we will need a group of data to find range in Google Sheets.

Step 1

First, you will need to make sure your data is tidy and clean to easily follow this tutorial.

Step 2

Before we can find the range, we need to name the range. To name the range, you can simply select the range you want, select ‘Data’, then select ‘Named ranges’.

Step 3

Then, a pop-up box will appear on the right-side of your screen. You can then name the range with your desired name. In this example, we will name it as ‘Revenue2022’.

Step 4

Now you can find the range in a formula. In this example, we want to find the sum of the entire year’s revenue. You can simply insert this formula =SUM(Revenue2022). As you can see, we can find the range named as ‘Revenue2022’ instead of using ‘B2:B13’.

Step 5

Once you press ‘Enter’, the formula will return the sum of the range in the cell.


That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to find range in Google Sheets. Want more? Check out all the Google Sheets Tutorials.