How to SUM a range of cells where the range for rows and cols for the formula come from cell input

[excel1072user]

Hello !! I tried various options and am stuck w/my limited knowledge!! its my first time here and am looking for some help.

Is there a way to SUM a range of cells where the range for rows and cols for the formula come from cell input ?

In the below example : I am looking for a formula to use in cell D1 that sums a range of cells based on the values I enter in cells A2, B2 & C2.

	A	B	C	D	E	F	G	H
1	col	begin row #	end row #	=sum(E3:E6)
2	E	3	6		1	3	6
3					2	5	3
4					5	6	2
5					6	6	2
6					6	6	5
7

<tbody>
</tbody>

Thanks for any help !

 

[Marcelo Branco]

Welcome to Mr Excel

Try
=SUM(INDIRECT(A2&B2&":"&A2&C2))

Hope this helps

M.

 

[excel1072user]

Thank you Marcelo ! It works !
I should have come here sooner and posted !

 

[Marcelo Branco]

You are welcome. Glad to help

M.