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.


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]col[/TD]
[TD]begin row #[/TD]
[TD]end row #[/TD]
[TD]=sum(E3:E6)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]E[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



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.