Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
 

Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
 

One way, use INDIRECT:
=SUM(INDIRECT("D4:D"&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:D(4+A2))

Can I made a cell reference variable? i.e. =sum(D4:D(4+A2))
 

"Max" wrote...
One way, use INDIRECT:
=SUM(INDIRECT("D4:D"&4+A2))
....

Why use a volatile function?

=SUM(D4:INDEX(D:D,4+A2))