David

Jeel is not dragging the D4 formula down column D. He is cutting and pasting
A4:C4 down to A11:C11

This will definitely change the formula in D4 as described.

My question to Jeel is........if you cut the data from A4:C4 why have a formula
in D4 referencing those cells?

You have left something out that I can't put my finger on.


Gord Dibben MS Excel MVP

On Wed, 30 Jan 2008 15:24:19 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

With =IF($C$4<1,0,SUM($K$4-$C$4)) in D4 if I drag it down to D11, or copy to
D11, it remains unchanged, so I don't know how you've got it to change to
=IF($C$11<1,0,SUM($K$4-$C$11)).
If you change the references from absolute to relative by removing the $
signs before the 4, and start with =IF($C4<1,0,SUM($K$4-$C4)), then it would
change to =IF($C11<1,0,SUM($K$4-$C11)) as you copy it down, butr that isn't
what you say you've done.

Another question is why you've got the SUM function in that formula? What
do you think SUM($K$4-$C$4) does for you that $K$4-$C$4 wouldn't? You may
wish to look in Excel help to remind yourself what SUM does.