sumifs

Hi All,

I want to calculate the consumption of Raw Material based on my Master Data and Finished Goods Production Report. 

Here, I have attached the 2 screen-shots 1st for Master Data where I have consumption of Raw Materials per PCS for each Finished Goods like;

and here I have production report, in Sold/Consumption column I want to calculate Total Consumption of Raw Material 1 based on Manufactured Units + Master Data.

Thanks,