How to add range of data by entering the cell number as input

[saranyatl]

Hello


If I enter the cell numbers at C1 & C2, The corresponding range of values in A should get added and displayed in C5. How to achieve this?


[TABLE="width: 379"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]Enter Row number for Start[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0.1[/TD]
[TD]Enter Row number for Stop[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0.2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0.3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0.4[/TD]
[TD]Sum[/TD]
[TD]3.5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0.5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0.6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0.7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]0.8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0.9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Note: Rows:1,2,3.... Columns:A,B,C...

 

[Gerald Higgins]

Perhaps something like this

=SUM(OFFSET(A1,C1-1,0,C2-C1+1,1))

 

[saranyatl]

Thank You.It is Working

 

[FlameRetired]

Another way.

=SUM(INDEX(A:A,$C$1):INDEX(A:A,$C$2))