indirect function

J

Joseph

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

Thanks.
Joe
 
F

Frank Kabel

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

Joseph

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
 

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

Using SUM(INDIRECT()) 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Problem with LARGE function 3
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Mac Excel 2011 and MS Excel 2007 #N/A 0
Indirect formula errors if file is closed 0
Looking to flip text in Excel file (2010) 0
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Top