store address in a cell and use it in formula

[Guest]

Hi,

Is it possible to store a cell range in a cell and use it in a formula. For
example store A1:A10 in a cell say B1 and use it in a formula say
=SUM(XX(B1)) so that sum of A1..A10 is returned. When ever value of B1 is
changed, formula should be re-calculated for fress address

 

[Guest]

You could use: =SUM(INDIRECT(B2))
where B2 contains the text: A1:A10