Hi!

Try this:

=IF(OFFSET(WorkSheet!C$10,(ROWS($1:1)-1)*12,,)="","",OFFSET(WorkSheet!C$12,(ROWS($1:1)-1)*12,,))

Biff

"MartinW" wrote in message
...
Hi Group,



I have 2 sheets. One called WORKSHEET one called REPORT.

In the report sheet I want to copy a formula down the page so

that the referenced cells increment by 12 instead of 1 as per

below.



C18 =IF(WORKSHEET!C10=0,"",WORKSHEET!C12)

C19 =IF(WORKSHEET!C22=0,"",WORKSHEET!C24)

C20 =IF(WORKSHEET!C34=0,"",WORKSHEET!C36)



I feel like this should be very simple but I just can't work it out,

Any help would be much appreciated.