Changing Criteria from absolute value to a range?

[cosmicgrooves]

This is the formula I have that works:

=SUMIF('2nd'!$J3:$J14,113,'2nd'!$O3:$O14)


Is there a way to do this, but instead of 113, how can I tell it greater than 100 but less than 200?


Thanks for any help offered.

[daddylonglegs]

You can't do that directly in SUMIF. One way is like this

=SUMPRODUCT(('2nd'!$J3:$J14>=100)*( '2nd'!$J3:$J14<=200),'2nd'!$O3:$O14)