Dynamic Cell References in Excel

[nogga]

Hello

Is there a way to generate cell references based on values from other cells?

What i would like to achieve
I have a formula like =SUM(A1:B5)
is there a way to set this references dynmacly via text in another cell?

like in the example below
the references should be read from the "fromcell" "tocell" entrys

A B C D E
1 1 1 from cell : A1
2 1 1 to cell: B4
3 1 1
4 1 1
5 1 1
6
7 10

 

[Gary''s Student]

=SUM(INDIRECT(E1&":"&E2))

So if E1 contains A1 and E2 contains B4, then function will give the same
results as =SUM(A1:B4)

 

[nogga]

Thanks for the answer!

=SUM(INDIRECT(E1&":"&E2))

So if E1 contains A1 and E2 contains B4, then function will give the same
results as =SUM(A1:B4)