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
|