SUMIF or SUMPRODUCT or...

[lifeisaspreadsheet]

Hi All,

I need to caculate on a daily basis the Weight Per Pack of Food Items that are distributed amost staff members. Attached is a sample of my data.

I've tried the following formulas:

=SUM(SUMIF(Sheet1!A:A,{"Apples","Bannas","Grapes"},Sheet2!$C:$D)) - Column B - Sheet 1
=SUMPRODUCT((Sheet2!A:A="Sheet1!A3")*(Sheet2!A:A="Sheet1!B4")) - Column B - Sheet 2

But success seems to be a distant relative at this stage......

I need to be able to update values in Colum B of Sheet 1 using the data from Sheet 2. One important thing to be noted is that I can not in any case, merge Column C and D of Sheet 2 in Sheet 2, but at the sametime have to consolidate the weights in Column B of Sheet 1.

Kindly review and advise...

Looking for your expertise...

Best Regards