copy a formula that skips rows

**mo2982** · 06-09-2014, 09:02 AM

Hi all

I would like to copy a formula that skips every 3 rows down a column.

My current formula is in cell D104: =(1+'Datasheet Monthly'!D307/100)+(1+'Datasheet Monthly'!D308/100)*(1+'Datasheet Monthly'!D309/100)-1

In D105, I would like to have: =(1+'Datasheet Monthly'!D310/100)+(1+'Datasheet Monthly'!D311/100)*(1+'Datasheet Monthly'!D312/100)-1

and then repeating down the column the same.

Any help is appreciated.

thanks
Mo2982

**sktneer** · 06-09-2014, 09:30 AM

Try this.....

=(1+INDIRECT("'Datasheet Monthly'!D"&307+(ROWS($1:1)-1)*3)/100)+(1+INDIRECT("'Datasheet Monthly'!D"&308+(ROWS($1:1)-1)*3)/100)*(1+INDIRECT("'Datasheet Monthly'!D"&309+(ROWS($1:1)-1)*3)/100)-1

**mo2982** · 06-09-2014, 10:41 AM

yes, thank you very much, this is the formula i needed.

Is this same reference able to be copied across the current worksheet? For example in cell E104, I would like the same formula