Allocate costs accordint following distribution rules

Hi everyone!

I need to allocate costs into a table according to allocation rules I have in another sheet. Hopefully someone will be able to help me.

The information I have has the following format:

Activity Service Cost Pool 1 Cost Pool 2 Cost Pool N
XXX YYYY $$$ $$$ $$$$$

In a separete table I have the allocation table I need to follow in the following format:

Activity Service Cost Pool Allocate to driver:
XXXX YYYY 1 A124
ZZZZ YYYY 1 A125

My goal is to create a sheet with Activity/Service/Driver that will give me the $$$$ per driver. i.e.

Activity Service Driver A124 Driver N
XXX YYYY $$$$$ $$$$

I hope I was able to decribe the problem otherwise I can go into more details. Is it possible to create Macro/Something that will follow this rules and distribute the costs in the different drivers?

Thanks for the time and help!

Hi

From your description, I think that SUMPRODUCT will be able to do what you want.

Can you build a small spreadsheet, showing your structure for the 3 sheets, and with some dummy data and expected results for that data. Zip it and attach to the post.


rylo