Add total values based on within range based on critera

Hi all

Any help will be greatly appreciated.

I'm looking for a formula to add the total of values within a column based on a specific cell criteria.

For example I need to set the criteria within (sheet1) A3 and then match that to range (Sheet2) D2:D1500. If there is a match in range (sheet2)D2:D1500 then add the values in range (Sheet2) K2:K1500.

I have looked and played with SumProduct, Countifs, etc but cant figure it out

I hope this makes sense?

Thanks