=INDIRECT("worksheet1!C" & ROW(1:1)*34)


"DaLuB" skrev:

I have a worksheet with a "weekly total" on several locations (34 rows apart)
that needs to be put into a second worksheet in a column next to the week
ending date. The formula being used is simply "=worksheet1!C34" and the next
one will need to be "=worksheet1!C68" and so on. I can't figure out what
formula to use to increase the row 34 places and attaching "+34" gives me
just that, the total + 34. HELP!