=SUM(INDIRECT("a1:a"&c1))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"yshridhar" wrote in message
...
Helloo everybody
I want SUM(A1:the value entered i C1). Say if C1=6, SUM(A1:A6). I tried
SUM(A1:address(c1,1)), resulted in error.
Any suggestions pls.
Thank you all
Sridhar