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

Google Sheets tutorials›Spreadsheet basics›Use a named range in a formula

Google Sheets · Verified tutorial

Use a named range in a formula in Google Sheets

Create a named range called Expenses for B2:B4. In C2, enter =SUM(Expenses).

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create a named range called Expenses for B2:B4. In C2, enter =SUM(Expenses).

Step-by-step

1

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

2

Apply the changeIn C2, enter =SUM(Expenses).

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

C2 uses the named range and returns 500.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select B2:B4 and repeat the final action. C2 uses the named range and returns 500.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount	Total
Hosting	80
Software	120
Ads	300

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a named range called Expenses for B2:B4.
Apply the change. In C2, enter =SUM(Expenses).
C2 uses the named range and returns 500.