Thread
:
formula help
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett