MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add numbers across Multiple Worksheets


Posted by spencer astle on September 23, 2001 11:43 PM

I'm trying to total a qty across multiple worksheets.

The totals are in the same cells on all the worksheets, but the number of worksheets can vary.

Is there a way to total ALL worksheets rather than having to specify each one by name?


Posted by Gianni on September 24, 2001 5:12 AM


Insert two new blank sheets.
Put one of these sheets immediately before the first sheet to be summed and name it "Start".
Put the other sheet immediately after the last sheet to be summed and name it "End".
Use the following for your sum formulas :-
=Sum(Start:End!A1)
Sheets can be added and deleted between "Start" and "End" without the formula being affected.