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")
=SUMIFS(Z$6:Z$9711,$F$6:$F$9711,">.74",$D$6:$D$9711,"<>Lost")