Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total schedules
Hello
I have 51 sheets in the same workbook. The front sheet is a summary sheet of the 50 behind. Each sheet has a list of codes with a value next to it, but the same code is not on the same line in each sheet. On the summary sheet I would like to add up all the values inline with a specific code What is the easiest way of doing this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total schedules
You can do this with a Pivot Table; in Step 1 specify Multiple Consolidation
Ranges OR Google for Excel Consolidation to find add-ins (not free) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joe" wrote in message ... Hello I have 51 sheets in the same workbook. The front sheet is a summary sheet of the 50 behind. Each sheet has a list of codes with a value next to it, but the same code is not on the same line in each sheet. On the summary sheet I would like to add up all the values inline with a specific code What is the easiest way of doing this? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total schedules
The alternative is to use Data | Consolidation.
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joe" wrote in message ... Hello I have 51 sheets in the same workbook. The front sheet is a summary sheet of the 50 behind. Each sheet has a list of codes with a value next to it, but the same code is not on the same line in each sheet. On the summary sheet I would like to add up all the values inline with a specific code What is the easiest way of doing this? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total schedules
1) Download and install the free add-in Morefunc.xll
2) Create two new sheets, and name them First and Last 3) Place all relevant sheets between First and Last 4) Then try the following formula... =SUMPRODUCT(--(THREED('First:Last'!CodeRange)="Code"),THREED('Fi rst:Last' !RangeToSum)) If the code is a numerical value, remove the quotes from the criteria. The add-in can be downloaded in the following link... http://xcell05.free.fr/ Hope this helps! In article , "Joe" wrote: Hello I have 51 sheets in the same workbook. The front sheet is a summary sheet of the 50 behind. Each sheet has a list of codes with a value next to it, but the same code is not on the same line in each sheet. On the summary sheet I would like to add up all the values inline with a specific code What is the easiest way of doing this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
Subtotal | Excel Worksheet Functions | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions |