Same range
=SUM(January!B2:B20,February!B2:B20,March!B2:B20)Adds several ranges.
PASTE-READY RECIPE
Sum Across Multiple Sheets in Google Sheets
Add the same cell or range from several worksheet tabs.
QUICK ANSWER
The formula and where it fits.
Add the same cell or range from several worksheet tabs. Use =SUM(January!B2,February!B2,March!B2), then replace the sample ranges with the columns in your sheet.
List each sheet reference inside SUM. Quote names that contain spaces.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | |
|---|---|---|
| 1 | Sheet | B2 value |
| 2 | ||
| 3 | ||
| 4 |
FORMULA OUTPUT3,975Recalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Sheet names with spaces
=SUM('Jan Sales'!B2,'Feb Sales'!B2)Single quotes protect names containing spaces.
Dynamic sheet list
=SUM(MAP(A2:A4,LAMBDA(s,INDIRECT("'"&s&"'!B2"))))Reads sheet names from cells.
COMMON ERRORS
When the result looks wrong.
A renamed tab returns #REF!
Choose the tab again in the formula so Sheets writes the current name.
INDIRECT slows a large file
Prefer direct sheet references when the tab list rarely changes.
QUESTIONS
Answers before you paste.
A renamed tab returns #REF!
Choose the tab again in the formula so Sheets writes the current name.
INDIRECT slows a large file
Prefer direct sheet references when the tab list rarely changes.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.