Help with adding up referenced data entries

Hi,

I have a table where I input data by product/item/month, attached a copy.

In table2 of the attachment, that i will place on a different sheet than table1, I want to add up all the items from table1 that have the same referencing as in cells B22 & C22 - in this case:

Cell E22 should look for ALL the items in table1 that have Product REF=1 and Item REF=1 under JAN and return the result of Jan*Weight*Packing - so E22 should be: G4*$F4*$E4 + G7*$F7*$E7. For FEB, it should read the figures for FEB*Weight*Packing
In Cell E23 it should do the same but with Prod REF=1 & Item REF=2 and so on.

I have tried the VLOOKUP but i couldnt figure out how to do multiple matching for the conditions.

Any help is really appreciated as I am stuck in this, I have researched it but couldnt come across any useful article to my case.

Regards,
Pete

I really cant thank you enough!
It works beautifully

Regards,
Pete

I really cant thank you enough!
It works beautifully

Regards,
Pete