Multiply using various criteria

[KeithStew]

Good day Excel Guru's

I have been trying to achieve the following with no success, I have tried using SUMIF with SUMPRODUCT but I have not been successful. I would greatly appreciate any guidance on the problem I am trying to solve.

In Summary I am trying to workout number of boxes per pallet, the challenge that I have is that there are four different box sizes supplied. I have categorised them and now I would like to multiply the 3 month stock holding by the number of boxes per pallet so I have a palletised figure to work with. If the box size is large then it needs to use the large number and that would apply for medium, small etc.

[TABLE="width: 1311"]
<tbody>[TR]
[TD]3 Months[/TD]
[TD]QTY Per Box[/TD]
[TD]Box QTY[/TD]
[TD]Palletised[/TD]
[TD]BOX Size[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]LARGE[/TD]
[TD][/TD]
[TD][/TD]
[TD]Pallet 110 x 110 x 120[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]50[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]SMALL[/TD]
[TD][/TD]
[TD]Small[/TD]
[TD]549[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]30[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]SMALL[/TD]
[TD][/TD]
[TD]Medium[/TD]
[TD]261[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]30[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]SMALL[/TD]
[TD][/TD]
[TD]Large[/TD]
[TD]144[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]40[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]SMALL[/TD]
[TD][/TD]
[TD]L[/TD]
[TD]32[/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance.

 

[Kamolga]

I would simply use vlookup

[/URL][/IMG]

 

[KeithStew]

Thank you I will try that, sometimes one tries to overcomplicate these things