Increment the Column Refs in a Formula

[dv0x]

Hello Ninjas,

How can I write a formula such that the column references auto-fill in fixed increments as demonstrated below?

CELL
F3: =COUNTIFS($CC:$CC,F$1,$CE:$CE,">0")/COUNTIF($CC:$CC,F$1)
F4: =COUNTIFS($CH:$CH,F$1,$CJ:$CJ,">0")/COUNTIF($CH:$CH,F$1) ; CC moves to CH, CE moves to CJ
F5: =COUNTIFS($CM:$CM,F$1,$CO:$CO,">0")/COUNTIF($CM:$CM,F$1) ; CH moves to CM, CJ moves to CO
F6: =COUNTIFS($CR:$CR,F$1,$CT:$CT,">0")/COUNTIF($CR:$CR,F$1) ; CM moves to CR, CO moves to CT

Many Thanks

 

[NARAYANK991]

Hi ,

See if this works :

=COUNTIFS(OFFSET($CC:$CC,,5*(ROW(A1)-1)),F$1,OFFSET($CE:$CE,,5*(ROW(A1)-1)),">0")/COUNTIF(OFFSET($CC:$CC,,5*(ROW(A1)-1)),F$1)

Narayan

 

[Deepak]

Check this...

=COUNTIFS(OFFSET($CC:$CC,,(ROW()-3)*5),F$1,OFFSET($CE:$CE,,(ROW()-3)*5),">0")/COUNTIF(OFFSET($CC:$CC,,(ROW()-3)*5),F$1)

Oops.. narayan already posted !!

 

[dv0x]

This solution works well. Thanks a lot!