Excel function to find unique reference and then add up all amounts

[ExcelLee]

Good afternoon all,

I am currently trying to think of a function to return values as per below however cannot get my head around it.

I am looking to use the different UPC code in column A "Summary Sheet" as a unique identifier to search the UPC code in Column D "Produce Cheat Sheet". Once it finds a corresponding number it will take the total from column G "Produce Cheat Sheet" and add them together and show it in the column C "summary.

I have included images of the excel sheet.

Let me know if you need any more info.

 

[mikerickson]

=SUMIF('Produce Cheat Sheet'!D:D, Summary!A1, 'Produce Cheat Sheet'!G:G)