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