| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals of different worksheets.
Hi there
Please help. I have 43 different workbooks, each containing 9 named worksheets ie toys, carrots, flowers and cats containing about 11 columns of information. Basically I want the totals of "column B" on worksheet called "toys" in the 43 workbooks added up. I can put all 43 workbooks on one workbook if thats going to make it easier. Unfortunately the totals arent all in the same cell. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Producing Totals on All Worksheets | Excel Discussion (Misc queries) | |||
| Gathering totals from various worksheets | Excel Worksheet Functions | |||
| Sum totals of 55 worksheets on Sheet 55? | Excel Worksheet Functions | |||
| sharing totals between worksheets | New Users to Excel | |||
| what is the formula to add totals from two different worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
