Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM using results from an Adress-formula
Is there any (somewhat) simple way to make the the SUM-function operate 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 rows 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 sum of all cells from D16 to D35. In other words i want my "SUM(D2;D3)" act as if it contained the formula "SUM(D16;D35)". But since the result of the ADDRESS-funciton is a textstring it doesn't work. Is there any way to make the SUM-formula use the contents of cell D2 and D3 as cellrefenrences instead of text. Or is there any other way to achive the result I want. The point is to have a user interface were the user can select how many rows should be included in the summary and then that selection is "transfered" to the same two cells and those are used to get the result. -- Langbraten ------------------------------------------------------------------------ Langbraten's Profile: http://www.excelforum.com/member.php...o&userid=32980 View this thread: http://www.excelforum.com/showthread...hreadid=528096 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM using results from an Adress-formula
Try the INDIRECT( ) function - this should do what you want. Excel Help
has details. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM using results from an Adress-formula
This will do it =SUM(INDIRECT(D2):INDIRECT(D3))
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Langbraten" wrote in message ... Is there any (somewhat) simple way to make the the SUM-function operate 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 rows 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 sum of all cells from D16 to D35. In other words i want my "SUM(D2;D3)" act as if it contained the formula "SUM(D16;D35)". But since the result of the ADDRESS-funciton is a textstring it doesn't work. Is there any way to make the SUM-formula use the contents of cell D2 and D3 as cellrefenrences instead of text. Or is there any other way to achive the result I want. The point is to have a user interface were the user can select how many rows should be included in the summary and then that selection is "transfered" to the same two cells and those are used to get the result. -- Langbraten ------------------------------------------------------------------------ Langbraten's Profile: http://www.excelforum.com/member.php...o&userid=32980 View this thread: http://www.excelforum.com/showthread...hreadid=528096 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM using results from an Adress-formula
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 two cells D16 and D35 from my example below. Now I'm gonna rule my project -- Langbraten ------------------------------------------------------------------------ Langbraten's Profile: http://www.excelforum.com/member.php...o&userid=32980 View this thread: http://www.excelforum.com/showthread...hreadid=528096 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
How do I delete the formula but keep the results | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |