Embedded Offset

[ddolson]

Can I use the offset function to change the actual cell reference number... In other words, if I have a formula that references (B1:BY1), can i use the offset function to make it reference B(1+offset):BY(1+Offset)? I haven't been able to crack this one.

 

[Aladin Akyurek]

Can I use the offset function to change the actual cell reference number... In other words, if I have a formula that references (B1:BY1), can i use the offset function to make it reference B(1+offset):BY(1+Offset)? I haven't been able to crack this one.

Might depend on the intended use...

INDEX(B:BY,E1,0)

means all column cells of B:BY from row that is in E1.

E1: 3

=SUM(INDEX(B:BY,E1,0))

would sum in effect all numbers in B3:BY3.