Creating a reoccuring OFFSET on a COUNTIF formula

[excelCADfan]

I'm using countif to return a total from another table. I need it to keep repeating this pattern as the following:
=COUNTIF(CO8:CO27,">0")

Next rows down should read the following:
=COUNTIF(CO29:CO48,">0")
=COUNTIF(CO50:CO69,">0")
and so on for 1000 rows.

I need to find a quick way to get this data filled for the rest of the template but I can't click and drag.
Thanks!!!

[Jonmo1]

Try

=COUNTIF(OFFSET($CO$8:$CO$27,(ROWS(A$1:A1)-1)*21,0),">0")

DO NOT change the A$1:A1 reference, it is not related to your data.