View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
macgilgamesh
 
Posts: n/a
Default Calculating Cells across worksheets??


Hello,

I have an Excel file that contains 13 sheets (one for each month and a
totals sheet). Rows "3-28, 30-48, 50-52", and "54-57" all tally
horizontally across and the sum for each row is posted in column "AH".


The question I have is how do I get the sum from each row to tally
across all of the worksheets and tally up on the thirteenth "05-Totals"
worksheet?

Example:
Worksheet names: Jan05, Feb05, Mar05, Apr05, May05, Jun05, Jul05,
Aug05, Sep05, Oct05, Nov05, Dec05

I need to add the "AH3" cells from each of the above monthly sheets and
show the total on the sheet "05-Totals" in cell "B3". Step and repeat
for each of the other rows...

Thanks in advance for all of your help...
Doug


--
macgilgamesh
------------------------------------------------------------------------
macgilgamesh's Profile: http://www.excelforum.com/member.php...o&userid=27930
View this thread: http://www.excelforum.com/showthread...hreadid=508730