How to create a range address with ADDRESS function?

  • Thread starter Thread starter Steve McLeod
  • Start date Start date
S

Steve McLeod

I can use this formula, =INDIRECT(ADDRESS(10,2)), but I haven't figured out
how to specify a range as in =INDIRECT(ADDRESS(10,2) & ":" & ADDRESS(30,6)).
I can put the range address into a cell and then reference the cell with
INDIRECT, but it would be nice to imbed the range address calculation inside
the INDIRECT function and save the step.
 
Your initial try is actually correct! It's just a matter of using it the
right way. For example:

=SUM(INDIRECT(ADDRESS(1,2) & ":" & ADDRESS(10,10)))

will work just fine
 
Back
Top