autosum formula skips cell

[Ruth]

hi,
I have a column of numbers, C7:C135, I highlight C7 to
C135, click on the AutoSum button, it gives me the correct
result in C136 but the formula reads =SUM(C8:C135) this
causes a problem when the value in C7 changes its not
reflected in the total at C136.
Has anyone else experienced this? Any ideas as to why its
behaving this way?
thanks
Ruth

 

[Vaughan]

What's in C7?

 

[Guest]

a number value, no formula
example
c7 holds value --> 10
c8 holds value --> 5
c9 holds value --> 20
c10 AutoSum --> 35 but formula displays SUM(C8:C9) so the
result is correct but the formula is not, so that when C7
value changes C10 becomes incorrect...I've never run into
this before.
thanks for your help,
Ruth

 

[Vaughan]

That is really wierd. I'm sorry, but I have never come across anything like
that before.

 

[David McRitchie]

Hi Ruth,
I presume that after hitting the AutoSum button that
you have cells A8:A135 selected instead of A7:A135
look at the value in A7 it is text. It may look like
a number. You could try F2 then enter for Cell A7 to
reenter it if you changed the format.

=ISTEXT(A7)
=ISNUMBER(A7)
If you got your data from a web page or possibly word you might
have non breaking spaces, Char(160), you can run further checks
with =LEN(A7) and others at
http://www.mvps.org/dmcritchie/excel/join.htm#debugformat
The TRIMALL macro can be used to fix up most such problems.