SUM using results from an Adress-formula

[Langbraten]

Is there any (somewhat) simple way to make the the SUM-function operat
with the text-strings returned by the ADDRESS-function?

Example:

[Cells C2] = 16
[Cells C3] = 35
[Cells D7] = 4

In my application C2,C3 are input cells were the user selects wich row
he/she is to incude in the summary.

[Cell D2] = ADRESS($C$2;D$7;4) which returns "D16"
[Cell D3] = ADRESS($C$3;D$7;4) and the result is "D35"

Then in [Cell D4] I want to use SUM(D2;D3) and have it return the su
of all cells from D16 to D35. In other words i want my "SUM(D2;D3)" ac
as if it contained the formula "SUM(D16;D35)".

But since the result of the ADDRESS-funciton is a textstring it doesn'
work.
Is there any way to make the SUM-formula use the contents of cell D
and D3 as cellrefenrences instead of text. Or is there any other way t
achive the result I want.

The point is to have a user interface were the user can select how man
rows should be included in the summary and then that selection i
"transfered" to the same two cells and those are used to get th
result

 

[Pete_UK]

Try the INDIRECT( ) function - this should do what you want. Excel Help
has details.

Hope this helps.

Pete

 

[Bernard Liengme]

This will do it =SUM(INDIRECT(D2):INDIRECT(D3))

 

[Langbraten]

Thanks a bunch!!!!! That did the trick!!!

I have tried INDIRECT before but it didn't succeed. I now realize why
by mistake I used ";" instead of ":" and thus made it SUM only the tw
cells D16 and D35 from my example below.

Now I'm gonna rule my project :cool