total schedules

J

Joe

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
 
B

Bernard Liengme

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
 
D

Domenic

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('First: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!
 
Top