| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
=SUM(A1:INDIRECT("A"&C1))
"yshridhar" skrev: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
Thanks alot. The reply is excellently fast.
With regards Sridhar "excelent" wrote: =SUM(A1:INDIRECT("A"&C1)) "yshridhar" skrev: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
=SUM(A1:OFFSET(A1,C1-1,))
or =SUM(A1:INDEX(A1:A9,6)) "yshridhar" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
Your formula fail if data start other than A1
C1: holds 6 eg. =SUM(A5:INDIRECT("A"&C1)) "excelent" wrote: =SUM(A1:INDIRECT("A"&C1)) "yshridhar" skrev: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
Your formula fail if data start other than A1
C1: holds 6 eg. =SUM(A5:INDIRECT("A"&C1)) "Don Guillett" wrote: =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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
=Sum(A1:Index(A:A,C1))
-- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Teethless mama" wrote in message ... =SUM(A1:OFFSET(A1,C1-1,)) or =SUM(A1:INDEX(A1:A9,6)) "yshridhar" wrote: 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help
Thanks RD for your simple formula. I think INDEX is more advantegious than
OFFSET or INDIRECT (being volatile). With regards Sridhar "RagDyeR" wrote: =Sum(A1:Index(A:A,C1)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Teethless mama" wrote in message ... =SUM(A1:OFFSET(A1,C1-1,)) or =SUM(A1:INDEX(A1:A9,6)) "yshridhar" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
