Automatic Incrementing Column Reference Fromula

[chrismdusa]

I have been researching and working on this for hours. I've tried formulas using OFFSET, and INDIRECT, but can't seem to get it right.

In cell F9 I have $33.33, then 17 columns over in cell W9 I have $40.00, then 17 columns over again in cell AN9 I have $520.00. This continues every 17 columns over, with different amounts until the last one in cell ASI9.

I want to make a column of these amounts beginning in cell S17 going down, so I can add them all together in another formula. So in cell S17 right now I have =F9. What formula can I put in cell S18 to get the amount from cell W9 to appear there, but in a way that I can copy and paste into cells S18, S19, S20, etc going down giving me the amounts in cells W9, AN9, BE9, etc respectively.

Happy Memorial Day! And thanks all you veterans for your service! Thanks in advance for the Excel help!

 

[JoeMo]

In cell S17 enter:
=OFFSET($F$9,0,ROW($A1)*17-17)
and copy down.

 

[chrismdusa]

That did the trick. Thanks very much!

 

[JoeMo]

That did the trick. Thanks very much!

You are welcome - thanks for the reply.