Using the ADDRESS worksheet function

[bearchaser]

Can the cell address text string generated by the ADDRESS worksheet function be used as a reference for another calculation?

For example:
Could you use the ADDRESS worksheet function to define one end of a columnar SUM range? (Assuming all of the appropriate cells have numerical values.)

=SUM(ADDRESS(2,3):E2)

~Thanks

 

[Asala42]

How about:

=SUM(INDIRECT(ADDRESS(2,3)&":E2"))

 

[Aladin Akyurek]

=SUM(INDIRECT(ADDRESS(2,3,4)):E2)

=SUM(E2:INDIRECT(ADDRESS(2,3,4)))

or better:

=SUM(E2:INDEX(2:2,0,3))

By the way, these formulas involve a horizontal range.