formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Your formula fail if data start other than A1
C1: holds 6

eg. =SUM(A5:INDIRECT("A"&C1))
 
Your formula fail if data start other than A1
C1: holds 6

eg. =SUM(A5:INDIRECT("A"&C1))
 
=Sum(A1:Index(A:A,C1))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

=SUM(A1:OFFSET(A1,C1-1,))
or
=SUM(A1:INDEX(A1:A9,6))
 
Thanks RD for your simple formula. I think INDEX is more advantegious than
OFFSET or INDIRECT (being volatile).
With regards
Sridhar
 
Back
Top