The best way would be to have a hidden sheet called "Start" that
comes before your data worksheets and another hidden sheet called
"End" that comes after all your data worksheets. Then use the
formula
=SUM(Start:End!F32)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"czywrg"
wrote in message
...
The boss has a Excel file that has 20 to 40 sheets depending on
the work
load. One sheet is named "totals" . All the other sheets have
unique
names that have the total for that sheet in F32. The totals
sheet has
=sum in F32 that sums all the sheets in the workbook. When
sheets are
added or deleted it is a manual process. Any ideas on
automating this
process to get totals?
--
czywrg
------------------------------------------------------------------------
czywrg's Profile:
http://www.excelforum.com/member.php...o&userid=31051
View this thread:
http://www.excelforum.com/showthread...hreadid=537297