=SUMPRODUCT((A1:A10)=110)*(A1:A10)<=129)*(B1:B10) )

Change ranges to suit but cannot be whole columns i.e A:A is not valid

HTH

"JN" wrote:

I need to sum a range of numbers based on 2 different criteria. Example:

Col A Col B
101 5
112 10
125 5
130 20

I need to sum Col B if the numbers in Col A are between 110 & 129. The
correct answer would be 15. I've tried IF, AND and nesting them but
nothing is working correctly