store address in a cell and use it in formula
 

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

store address in a cell and use it in formula
 

You could use: =SUM(INDIRECT(B2))
where B2 contains the text: A1:A10
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gbalamani" wrote:
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