|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 11th, 2008, 02:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
|
|
#2
July 11th, 2008, 06:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
One way, use INDIRECT:
=SUM(INDIRECT("D4  "&4+A2))p/s: Never leave the message area blank. Use it to elaborate on your query. The subject line is just that, it's not the posting. -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "timothy" wrote in message ... Can I made a cell reference variable? i.e. =sum(D4 (4+A2))
|
|
#3
July 11th, 2008, 07:14 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
"Max" wrote...
One way, use INDIRECT: =SUM(INDIRECT("D4 "&4+A2)).... Why use a volatile function? =SUM(D4:INDEX(D ,4+A2))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
