Sumif over two worksheets

[gj80]

Hi

I have two worksheets

Worksheet 1
List of suppliers and product codes, some products have 2 suppliers (over 2000 products)

Worksheet 2
List of supplier, product codes and quantity sold. Multiple product codes are listed with different quantities and suppliers.

What I would like to do is show on worksheet 1 next to the product code for the supplier the total sum of sold by product.

Example
Works sheet 1
Supplier Stock Code Total sold
ABC 123
DEF 456
GEH 789
IJK 123


Worksheet 2

Supplier Stock Code Qty Sold
ABC 123 5
ABC 123 5
IJK 123 3

I have tried a sumif but not all the details are pulling through.

Can you please help?

Many Thanks

 

[Tetra201]

Is this what you need?

=SUMIFS(Sheet2!C:C,Sheet2!A:A,Sheet1!A2,Sheet2!B:B,Sheet1!B2)

 

[gj80]

Is this what you need?

=SUMIFS(Sheet2!C:C,Sheet2!A:A,Sheet1!A2,Sheet2!B:B,Sheet1!B2)

It works perfectly thank you.

 

[Tetra201]

You are most welcome.