Range value from cell input#

Copper Contributor

Please help. I really appreciate it. 

 

A1=100

A2=100

A3=100

A4=100

A5=100

 

A8 =SUM(A1:A5)

 A8 = 500

 

How can I get range from value in cell?

EX: C1= 3

 

A8 =SUM(A1:A(C1)      Where C1 would be 3  which will make A(C1) = A3

A8 = 300   

 

Again.  I really appreciate it. Thank you in advance.

 

MixStarFX. 

 

 

 

 

3 Replies

@MixStarFX 

That could be

=SUM(A1:INDEX(A1:A5,C1))
SORRY FOR THE LATE REPLY.
THIS WORKED PERFECTLY.
THANK YOU SO MUCH FOR THE INFO.

@MixStarFX 

You are welcome, glad to help