Sorry for the lapsus latina. If =SUM($A1:A20) is copied down, it will change
to =SUM($A2:A21). If =SUM($A$1:A20) is copied down, it will change to
=SUM($A$1:A21)

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Kassie" wrote:

There are a number of ways to achieve this. I take it that when you say you
do not want the formula to change, you do not want the cell addresses in the
formula to change.

If you use absolute cell addresses, it will not change. You do this by
adding a "$" before each parameter you do not want to change. Say you have a
formula in B1 that reads =SUM(A1:A20). If you copy this one row down, it
will change to =SUM(A2:A21). If you copy it to C1, it will change to
=SUM(B1:B20). Now you start adding $ signs.

If =SUM($A1:A20) is copied one row down, it will change to =SUM($A1:A21)
When copied one column over, it will change to =SUM($A1:B20)

if =SUM($A$1:A20) is copied down, it will change to =SUM($A$1:A21), and if
copied one column over, to =SUM($A$1:B20).

The same applies if $ signs are added before the second part of the formula,
eg =SUM($A$1:$A20) and =SUM($A$1:$A$20)

--
Hth

Kassie Kasselman
Change xxx to hotmail