Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
Heavily linked spreadsheet freezes with "calculating cells 0%" - . | Excel Worksheet Functions | |||
Calculating Cells - Slower in Smaller File | Excel Discussion (Misc queries) | |||
How do I unlink cells in different worksheets when there are no a. | Excel Worksheet Functions |