VBA or PQ or Formula or Pivot Table?

[nburaq]

Hi Gents,
I would like to compare two sheets having 3 common dependent in each sheet and would like to see the difference at another sheet or in sheet2 specified column as "Difference" I tried Pivot table and xlookup but didn't work for me and I think this one needs VBA or PQ. I even don't know where to post this question... I attach the screenshots and gonna try to upload the data as well (xlbb crashed) Thanks for help and comments!

 

[nburaq]

To count the total of Qty in sheet1:

=SUMIFS(sheet1!C:C,sheet1!A:A,sheet2!B2,sheet1!B:B,sheet2!C2)

Is there any way to do it with sumproduct? Because sometime sumifs is not counting the correctly i dont know why... thanks again

 

[mart37]

=sumproduct((sheet1!A:A=sheet2!B2)*(sheet1!B:B=sheet2!C2),sheet1!C:C)