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

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

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

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