Total one cell (e.g. B2) across many tabs with a 3D reference.
Copy this formula
=SUM(Jan:Dec!B2)A 3D reference like Jan:Dec!B2 spans every sheet from the first to the last named tab. SUM then adds B2 from each — ideal for identical monthly sheets. The sheets must sit next to each other in tab order.
=SUM(Q1:Q4!D10)→48,200Total of D10 across four quarterly sheets.
=AVERAGE(Jan:Dec!B2)→4,015The same 3D reference works with AVERAGE, MAX, MIN and COUNT.
=SUM('2025 Q1:2025 Q4'!D10)→48,200Wrap the sheet names in single quotes when they contain spaces.
Yes — =SUM(Jan:Dec!B2:B20) sums the range across all the sheets.
A sheet placed between the first and last tabs is included automatically. A sheet outside that span is ignored.
No. 3D references work with functions such as SUM, AVERAGE, COUNT, MAX and MIN, but not with SUMIF, COUNTIF or lookup functions.
List them one by one: =Jan!B2+Mar!B2+Jun!B2.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.