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

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"gwhite" wrote in
message ...

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

Thanks,

Gary


--
gwhite
------------------------------------------------------------------------
gwhite's Profile:
http://www.excelforum.com/member.php...o&userid=25073
View this thread: http://www.excelforum.com/showthread...hreadid=385898