Just hazarding a guess here ...
Maybe something like this is what you're after?

Let's say you have a defined "base" range: MyR
which refers to: =Sheet1!$A$1:$A$4

Then you have this placed in Sheet1's A5:
=SUM(OFFSET(MyR,,COLUMNS($A:A)-1))
[ the above's the same as the much simpler: =SUM(A1:A4) ]

And you copy A5 across to B5, C5 etc to return the corresponding sums, all
of which are pegged to MyR.

If you have the above set-up, you could then amend MyR's range "centrally"
via clicking Insert Name Define, and adjust it to refer to say:
=Sheet1!$A$1:$A$3 instead. And when you do so, all the formulas in A5, B5, C5
etc would then adjust automatically to refer to the shortened range.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Flawlesgem" wrote:
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