indirect function

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

Does anyone know a way that I can use the indirect funtion to define a range
within the sum function?

Thanks.
Joe
 
Hi
you ned to be a little bit more specific what you're trying to do. In
general this is no problem
 
Frank,

=ADDRESS(2,1,1,1,"W:\Forecast\Dashboard\"&MID(B2,6,4)&"\["&LEFT(B2,9)&"
Upshot Download Deals Report.xls]Weekly Backlog Deal Report 04'!")

The above formula defines a single cell.

I want to implant it into =sum() and have it use that cell as the starting
point and use cell a23 as the endpoint of the range.

Thanks.
Joe
 
You must log in or register to reply here.

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

Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Problem with LARGE function 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Indirect reference causes statistical function to throw up a #NUM! 10
referencing a range in Sumproduct function 6
Need array formula to ignore hidden values 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Back
Top