Greater than vs less than vs Between

[RodneyC]

These two formulas work:

=SUMIFS($G17:$G2000,$H17:$H2000,$B3,$F17:$F2000,"<1")

=SUMIFS($G17:$G2000,$H17:$H2000,$B3,$F17:$F2000,">5")

But I need to modify so it SUMIFS the value is (for example) greater than 0 but less than 1.

thanks in advance

 

[Fluff]

How about

=SUMIFS($G17:$G2000,$H17:$H2000,$B3,$F17:$F2000,">0",$F17:$F2000,"<1")

 

[RodneyC]

How about

=SUMIFS($G17:$G2000,$H17:$H2000,$B3,$F17:$F2000,">0",$F17:$F2000,"<1")

Yahtzee! That works, thanks

 

[Fluff]

You're welcome & thanks for the feedback.