Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Address Location
Hello, I am using the below formula to create the address of a cell range that i need to sum. Unfortunately it does not see the address as an address. How do i use the the ouput of this formula in a sum formula. ="'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26) Output: 'Dec 05'!$V$6:$Z$6 Thanks, Chris -- drizzt04240 ------------------------------------------------------------------------ drizzt04240's Profile: http://www.excelforum.com/member.php...o&userid=29264 View this thread: http://www.excelforum.com/showthread...hreadid=489822 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Address Location
=SUM(INDIRECT("'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec
05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26))) -- HTH RP (remove nothere from the email address if mailing direct) "drizzt04240" wrote in message ... Hello, I am using the below formula to create the address of a cell range that i need to sum. Unfortunately it does not see the address as an address. How do i use the the ouput of this formula in a sum formula. ="'Dec 05'!" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),22) & ":" & ADDRESS((ROW(OFFSET('Dec 05'!A6,MATCH(A2,'Dec 05'!A6:A300,0)-1,0))),26) Output: 'Dec 05'!$V$6:$Z$6 Thanks, Chris -- drizzt04240 ------------------------------------------------------------------------ drizzt04240's Profile: http://www.excelforum.com/member.php...o&userid=29264 View this thread: http://www.excelforum.com/showthread...hreadid=489822 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Address Location
Thank you very much, that worked great. -- drizzt04240 ------------------------------------------------------------------------ drizzt04240's Profile: http://www.excelforum.com/member.php...o&userid=29264 View this thread: http://www.excelforum.com/showthread...hreadid=489822 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Using a Cell Value in another Cell Address | Excel Worksheet Functions | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |