Thomas Pike wrote...
....
So my current range in one summary cell is =COUNTIF(J1:J10,".5") then
the next summary cell has =COUNTIF(J11:J21,".5") for groups of 10. Now
if I were to change the value in cell L1 to 20, I would like to see my
statements change to =COUNTIF(J1:J20,".5"), =COUNTIF(J21:J40,".5"),
etc.

If the first formula were in cell X99 and the second in cell X100, you
could try the following formula in cell X99

X99:
=COUNTIF(OFFSET($J$1,(ROWS(X$99:X99)-1)*$L$1,0,$L$1,1),".5")

then fill X99 down into X100.