Greater than and Less than Operator

[Eb0la11]

Ive got a working formula here where I am seeing if something is greater than 74% right now and want to also say less than 100% (1). How would I adjust this formula to do that?

=SUMIFS(Z$6:Z$9711,$F$6:$F$9711,">.74",$D$6:$D$9711,"<>Lost")

 

[Jonmo1]

Just add another criteria

=SUMIFS(Z$6:Z$9711,$F$6:$F$9711,">.74",$F$6:$F$9711,"<1",$D$6:$D$9711,"<>Lost")