Adjust range formula

[diems]

Hi everyone on the board,

This formula counts 24x6 cells and puts the result in range TA94:TG117

        [TA94:TG117].FormulaR1C1 = "=COUNT(OFFSET(RC,44+(5*(ROW(R[-93]C1)-ROW(R1C1))),,6))"

Now I want adjust this formula so it will count 18X6 cells and puts the result in range G48:AN65, but it's a bit to complicated for me..

[G48:AN65].FormulaR1C1 = "=COUNT(OFFSET(RC,44+(5*(ROW(R[-93]C1)-ROW(R1C1))),,6))"

Any help is appreciated!

 

[diems]

I mean too complicated for me..

 

[diems]

I got it fixed!


Best regards