Multipe Countifs, better way?

[Phillytown]

Hello,
My first post but I have used the forum as a reference in the past. Great place. Anyway, below is my formula. I am thinking there must be a better way since the list will go longer and I'd rather not have to add new Countifs each time. Just looking for an easier way. Thanks!

=COUNTIFS(Main!F10:M10,"<1",Main!F10:M10,">0.79")+COUNTIFS(Main!F18:M18,"<1",Main!F18:M18,">0.79")+COUNTIFS(Main!F26:M26,"<1",Main!F26:M26,">0.79")+COUNTIFS(Main!F34:M34,"<1",Main!F34:M34,">0.79")+COUNTIFS(Main!F42:M42,"<1",Main!F42:M42,">0.79")+COUNTIFS(Main!F50:M50,"<1",Main!F50:M50,">0.79")+COUNTIFS(Main!F58:M58,"<1",Main!F58:M58,">0.79")

 

[Aladin Akyurek]

Hello,
My first post but I have used the forum as a reference in the past. Great place. Anyway, below is my formula. I am thinking there must be a better way since the list will go longer and I'd rather not have to add new Countifs each time. Just looking for an easier way. Thanks!

=COUNTIFS(Main!F10:M10,"<1",Main!F10:M10,">0.79")+COUNTIFS(Main!F18:M18,"<1",Main!F18:M18,">0.79")+COUNTIFS(Main!F26:M26,"<1",Main!F26:M26,">0.79")+COUNTIFS(Main!F34:M34,"<1",Main!F34:M34,">0.79")+COUNTIFS(Main!F42:M42,"<1",Main!F42:M42,">0.79")+COUNTIFS(Main!F50:M50,"<1",Main!F50:M50,">0.79")+COUNTIFS(Main!F58:M58,"<1",Main!F58:M58,">0.79")

Control+shift+enter, not just enter:

=SUM(IF(MOD(ROW(F10:F58)-ROW(F10),8)=0,IF(F10:M58 > 0.79,IF(F10:M58 < 1,1))))

 

[dispelthemyth]

Excellent use of MOD(ROW(F10:F58)-ROW(F10),8) to get the division of 8

Control+shift+enter, not just enter:

=SUM(IF(MOD(ROW(F10:F58)-ROW(F10),8)=0,IF(F10:M58 > 0.79,IF(F10:M58 < 1,1))))