Hi all,

Is there any possibility that multiple cells are linked to one cell and
applying the same formula with column or row increament and modified
autometically as orignal cells formula change, for example

In A5 formula is: =Sum(A1:A4)
In B5 (which is required to be linked with A5) has fomula bse on A5 formula
with column increament i.e. =Sum(B1:B4)

I need to know that if there is any possibility that when i change the range
of formula in cell A5 (for example from =sum(a1:a4) to =sum(a1:a3)) the cell
B5 autometically incorporate the change and modified its own formula (from
=sum(b1:b4) to =sum(b1:b3))

If there would be any possibility than it would be really helpful