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.
Yes — =SUM(Jan:Dec!B2:B20) sums the range across all the sheets.
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.