formula to reference cell a1 plus 5 rows

[David Des]

can a formula be written that will reference a cell 5 rows below A1?

 

[David Des]

I want to make a series of formulas that will each time add a certain amount of rows to be referenced, starting at A1

 

[dreid1011]

Yes, it's possible. Should the reference include all the cells from A1 to the reference cell or just that single cell?

 

[David Des]

that single cell

 

[dreid1011]

that single cell

Then perhaps OFFSET(A1,C1,,1,1), where A1 is your starting point, and C1 contains a number for how many rows you would like to go. The 1, 1 (height, width) at the end determines the size of the offset.

Now it just depends on what you would like the formula to do.

 

[David Des]

thank you dreid. that does what i asked but is not really what i wanted. I will start a new thread and try to explain what i really want to do (looked at attaching file but am not able to understand the procedure)

 

[David Des]

Dreid, i thought about it and played around a little and used the offset to solve my problem. Thanks

 

[Peter_SSs]

Dreid, i thought about it and played around a little and used the offset to solve my problem. Thanks

Welcome to the MrExcel board!

Just be aware that OFFSET is a volatile function so may adversely affect your sheet's performance if used a lot.

There is almost certainly a non-volatile way to achieve the same thing so if you need that or are interested, tell us a bit more about what you have, where, and what you are trying to achieve, as well as the formula using OFFSET that you have ended up with at the moment. If you want to post a small set of dummy data and expected results to help clarify your situation, my signature block below has a link to follow.