lookup and match formula help please :)

[PierremontQuaker03]

Hi I need some help in filling this spreadsheet in without doing it manually. All the info is coming from the Raw Data tab.
Taking the first section in the data tab (levant classic) I am wanting a formula for the sun of quantity (column F) and the sum of value column G).
So the formula would need to look at the column D for the customer number, look at the product number (for Levant classic it is “1100”) and then populate the total quantity and sales coming from the raw data tab.
Any help would be great thank you.

 

[p45cal]

I can't link your columns either with your narrative nor with the headings on the Data sheet, so I've added a pivot table (less than 3 minutes to set up) to give you an idea of how to get the summary data you want. See attached.