I am facing some trouble creating a formula.

In the first sheet, I have my orders listed. Each order contains the following collums: [Product code] [Product name] [Quantity] [Amount]

In the second sheet, I want to create an overview of the total quantities sold per product code.

Therefore, I need a formula that looks up where the product code appears, and when it appears counts the quantities.

I have tried for an hour now and can't figure out how to do this.

Anyone has an idea how to do this?

Thanks in advance!