Why does this formula change?

B

bdunk

I have a sheet with a simple sum formula in O30 summing C30 to I30. Th
sum works correctly when I enter numbers into this range of cell
however when I go to enter a number in H30, a number that I do not wan
included in the Sum formula in O30, the formula in O30 automaticall
changes itself to include H30. How can I enter numbers in thes
columns and have the formula not change?

Thanks much Bdun
 
F

Frank Kabel

Hi
if your formula is
=SUM(C30:I30)
than it's o.k. to include H30. So the formula does not change?
 
B

Bill Ridgeway

A formula does not change. What does happen though is our perception of
what the formula should do and what we have told it to do is out of kilter.
We have all been in the why the ... doesn't this work and after a lot of
sweat and stress find that it needed only a small change to fix.

I find that following the steps in a formula using a calculator often helps
unravel those simple but infuriating errors.

Regards.

Bill Ridgeway
Computer Solutions
 
E

Earl Kiosterud

Bdunk,

I'm a little confused, since H30 is already in the range of C30:I30.

If the extents of the SUM's range are changing, you may have "Extend list
formats and formulas" checked in Tools - Options - Edit.
 
Top