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))