total schedules

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 28 Oct 2006 17:24 GMT

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 to this Message

Bernard Liengme - 28 Oct 2006 18:08 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hello
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Bernard Liengme - 28 Oct 2006 18:42 GMT

The alternative is to use Data | Consolidation.

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hello
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Domenic - 28 Oct 2006 19:42 GMT

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!

> Hello
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message