Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
drizzt04240
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
drizzt04240
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can the column index in a cell address be made variable? cyberdude Excel Discussion (Misc queries) 1 November 20th 05 03:47 AM
Using a Cell Value in another Cell Address samccaskill Excel Worksheet Functions 2 October 4th 05 09:41 PM
ADDRESS function - dynamic input cell claytorm Excel Discussion (Misc queries) 1 June 28th 05 02:05 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"