New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Create a named range

Google Sheets · Verified tutorial

Create a named range in Google Sheets

Create a named range called QuarterlyRevenue for B2:B4. Then enter exactly =SUM(QuarterlyRevenue) in D2.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create a named range called QuarterlyRevenue for B2:B4. Then enter exactly =SUM(QuarterlyRevenue) in D2.

Step-by-step

1

Select the targetCreate a named range called QuarterlyRevenue for B2:B4.

2

Apply the changeThen enter exactly =SUM(QuarterlyRevenue) in D2.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

D2 uses the new named range and displays 540.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2:B4 and repeat the final action. D2 uses the new named range and displays 540.

Example spreadsheet data

This is the clean fixture used for the verified run.

Quarter	Revenue		Total
Q1	120
Q2	180
Q3	240

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a named range called QuarterlyRevenue for B2:B4.
Apply the change. Then enter exactly =SUM(QuarterlyRevenue) in D2.
D2 uses the new named range and displays 540.