Summary Sheet Totals

[gwhite]

I have a workbook that tallys values from 30 or so separate sheets. I
there an easy way to have a summary sheet that looks at specific cell
on each sheet? Right now, I have to do a simple SUM function where
manually click on each cell on each sheet I want in the total. I'
thinking there is a way to do this with a formula/array.

Thanks,

Gar

 

[Anne Troy]

Here you go:
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Dave Peterson]

Are they always in the same position (summing A1 of all the sheets or b22 of all
sheets)?

If yes...

You create two "helper" worksheets. One named Start and one named Finish.
(Lock all the cells and protect these two worksheets--just so no one uses them.)

Put all your "data" worksheets (and no others!) between those two worksheets.

Then you can use this on the summary sheet (outside that "sandwich")

=sum(Start:Finish!a1)

The users could even play what-if games. If they drag a data worksheet out of
the Start:Finish sandwich, then that worksheet's values will be ignored.

 

[gwhite]

Great Stuff! Works perfectly - thanks for the tip!