store address in a cell and use it in formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top