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

[Max]

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[/QUOTE]
Re: Can I made a cell reference variable? i.e. =sum(D4(4+A2))

 

[Harlan Grove]

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

....

Why use a volatile function?

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