open ended multi page sum

[AlZee]

I have a workbook with multiple worksheets that are identical in format
I would like to add a summary sheet that adds all of the values of th
other pages, i.e., cell A1 on the summary page would be the sum of al
of the A1 cells on the other pages. The sheet also has text in man
boxes, but I could simply retype these on the summary page. Th
problem is that we do not know how many pages will be summed up at an
given time. It could be anywhere from 2 to 100 depending upon how man
people input data for this project. Not knowing ahead of time how man
"new" sheets will be provided is the problem. Any suggestion
(equations?) that will solve this? I would prefer not having t
pre-save 100 sheets in advance of getting input and have to copy an
paste on to each sheet, or have to manually change the summing equatio
everytime a new sheet arrives. I would prefer that the individual sheet
be inserted into the workbook where the summary sheet is and the summin
equations only look for "filled in" sheets

 

[Gord Dibben]

AlZee

Make the
Ssummary sheet the first sheet.

After that sheet insert a new sheet and name in StartSht.

At end of all sheets insert a new sheet named EndSht.

On Summary sheet enter =Sum(StartSht:EndSht!A1)

When inserting new sheets after this, make sure to insert between StartSht and
EndSht.

Gord Dibben Excel MVP

 

[Bernard Liengme]

Put in two dummy sheets: one in front, one at end
Let's call then Alpha and Omega
Have Summary sheet before Alpha or after Omega
Use =SUM(Alpha:Omega!A1) to sum

 

[Gord Dibben]

Ssummary should read Summary.

name in StartSht should be name it StartSht.

Any other typos I may have missed?

Gord