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

Originally Posted by benishiryo

hi johnny_p. a sample excel file with your desired results shown would be very useful. my guess is if the formula is in Sheet1, then:
=SUMIF(Sheet2!D2:D1500,A3,Sheet2!K2:K1500)

Your a star. It worked perfectly. Even better I knew where I went wrong

Thanks