Match funktion that calculates total amount of needed packagin

[a94andwi]

Hello.

In my logistics department we need to have a tool that helps us when to order new packaging material. Packaging is used differently if it is part 1 och 2 that is shipped which reguire a demand vs packaging instruction summary.
I have attaced a workbook with the basics in this and I need support how to write the summary formula which I think should use a index/match-formula with a twist.

I can't solve it myself and hope for some support.

/Anders

[Bo_Ry]

Please try at
B19:T23
=SUMPRODUCT(B$10:B$11/$B$3:$B$4*INDEX($C$3:$G$4,,MATCH($A19,$C$2:$G$2,)))

or Spill array

=MMULT(TRANSPOSE(C3:G4),B10:T11/B3:B4)

[a94andwi]

Thanks. It worked well with the sumproduct-formula!

/Anders

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. No need to edit the thread title.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.