Hi

Check that Tools/Options/Calculation is set to Automatic.

Andy.

"Peco Worker" wrote in message
...
I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
same column and it will not work. It gives me the correct formula but it
gives me the same answer as the cell copied from.

So if I start with b10-b11 and then copied it down into c10-c11, it
changes
the formula correctly. If the answer in for b10-b11 is 50 and the anwser
for
c10-c11 is 45 it still answers it as 50.

Has anyone else ever had this problem?