Offset question

[Poida68]

Hi all
So I've got some data on my worksheet "Setup Order:" I need to refer to.
For Week 1 the reference is C66:C69 on the Setup Order worksheet
For Week 2 the reference is C70:C72 on the Setup Order worksheet
And so on untill Week 16.
In other words an offset of 4

Now, on my AllResults tab for Week 1 in cell I1 I have the formula
=IF(COUNT(Setup: Order!C66:C69)*3^2=SUM(J8:J43)/3=FALSE,"RECHECK!","")

I want to copy this formula to cell I53 (Week 2) and I need it to be the equivalent of:

=IF(COUNT(Setup Order!C70:C72)*3^2=SUM(J60:J95)/3=FALSE,"RECHECK!","")

to work. How do I accomplish this ?

 

[Poida68]

OK, I think I fixed it.

In cell I1 I have =IF(COUNT(Setup: Order!C66:C69)*3^2=SUM(J8:J43)/3=FALSE,"RECHECK!","")

Then in cell I53 I have =IF(COUNT(OFFSET('Setup Order'!C118,4-ROW(I52),0,4))*3^2=SUM(J60:J95)/3=FALSE,"RECHECK!","")

(Since I need to refer to the cell 52 rows below cell I1, and then make this a range offset 4 down).

I can then copy I53 into cell I105 and so on every 52 cells down...

 

[Poida68]

Improved: In cell I1 I have =IF(COUNT(OFFSET('Setup Order'!C66,4*RIGHT($A1,2) - ROW(I1)-3,0,4))*3^2=SUM(J8:J43)/3=FALSE,"RECHECK!","")