Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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?

Re: Add numbers across Multiple Worksheets

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.