Thread: formula help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default formula help

=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