Range value from cell input#

%3CLINGO-SUB%20id%3D%22lingo-sub-1718936%22%20slang%3D%22en-US%22%3ERange%20value%20from%20cell%20input%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1718936%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help.%20I%20really%20appreciate%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA1%3D100%3C%2FP%3E%3CP%3EA2%3D100%3C%2FP%3E%3CP%3EA3%3D100%3C%2FP%3E%3CP%3EA4%3D100%3C%2FP%3E%3CP%3EA5%3D100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA8%20%3DSUM(A1%3AA5)%3C%2FP%3E%3CP%3E%26nbsp%3BA8%20%3D%20500%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20range%20from%20value%20in%20cell%3F%3C%2FP%3E%3CP%3EEX%3A%20C1%3D%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA8%26nbsp%3B%3DSUM(A1%3AA(C1)%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Where%20C1%20would%20be%203%26nbsp%3B%20which%20will%20make%20A(C1)%20%3D%20A3%3C%2FP%3E%3CP%3EA8%20%3D%20300%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain.%26nbsp%3B%20I%20really%20appreciate%20it.%20Thank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMixStarFX.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1718936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1719186%22%20slang%3D%22en-US%22%3ERe%3A%20Range%20value%20from%20cell%20input%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1719186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811335%22%20target%3D%22_blank%22%3E%40MixStarFX%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(A1%3AINDEX(A1%3AA5%2CC1))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766718%22%20slang%3D%22en-US%22%3ERe%3A%20Range%20value%20from%20cell%20input%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766718%22%20slang%3D%22en-US%22%3ESORRY%20FOR%20THE%20LATE%20REPLY.%3CBR%20%2F%3ETHIS%20WORKED%20PERFECTLY.%3CBR%20%2F%3ETHANK%20YOU%20SO%20MUCH%20FOR%20THE%20INFO.%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@MixStarFX 

That could be

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

@MixStarFX 

You are welcome, glad to help