How to create a range address with ADDRESS function?

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a Range with Address() 2
Indirect reference causes statistical function to throw up a #NUM! 10
INDIRECT(ADDRESS) inside a VLOOKUP 13
INDIRECT function to reference a named range 2
referencing a range in Sumproduct function 6
Using the Address Function 1
COUNTIF + ADDRESS Issue 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Top