Use two sumif functions... one adds up everything over 30, the other
everything over 60. Subtract to get those in (30-60]
=sumif(range,"30",sum_range) - sumif(range,"60",sum_range)

"JC" wrote:

I'm trying to use the SUMIF function with criteria that value must be 30 and
<=60. How would I code that with this function?