Dynamic Cell References in Excel
 

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

Dynamic Cell References in Excel
 

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

So if E1 contains A1 and E2 contains B4, then function will give the same
results as =SUM(A1:B4)
--
Gary''s Student - gsnu200840


"nogga" wrote:

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

Dynamic Cell References in Excel
 

Thanks for the answer!

"Gary''s Student" wrote:

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

So if E1 contains A1 and E2 contains B4, then function will give the same
results as =SUM(A1:B4)
--
Gary''s Student - gsnu200840


"nogga" wrote:

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