Why does this formula change?

  • Thread starter Thread starter bdunk
  • Start date Start date
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
 
Hi
if your formula is
=SUM(C30:I30)
than it's o.k. to include H30. So the formula does not change?
 
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
 
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.
 
Not quite sure how your spreadsheet is set up or what you are trying to do,
but if you want to exclude H30 try:
=sum(c30:g30,i30)

Hope this was helpful.
 
Back
Top