bearchaser
New Member
- Joined
- Oct 9, 2002
- Messages
- 1
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
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