Hi Bob,

Thanks for coming back.

I see what you say, but when I open up a spreadsheet that has worked in the
past with the data that is already in there, and I then try to delete a row
of data, I would have expected the SUM value to reduce by the deleted row
amount, that was what first alerted me to the problem.

However as I said to Vijay_India it is now a single cell worth of data that
is being ignored by the sum and indeed by a reference to it also, weird?



"Bob Phillips" wrote:

SUM will ignore text, but it will also ignore text that look like numbers,
this is what I am suggesting.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"knowq.biz/video.htm" wrote in
message ...
Hi Bob,
Thanks for the reply.

In the past I have not needed to distinguish for numbers all I type is for
example
1
or
even
2

I have not for example inserted
'1
or
'2


I have even tried using
=1
or
=2
and I get the same problem, ie SUM() gives 0

Could it be a nasty virus or spyware thing do you think?

"Bob Phillips" wrote:

You can't break the SUM function, but you can break the data. Is the
data
text not numbers?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"knowq.biz/video.htm"
wrote
in message ...
I have just opened a spreadsheet and tried changing data in my C
Column
but
noticed the results of the SUM formula did not change. I pressed
recalculate
F9 and still no change. Suspect some update has broken the SUM
functionality
- looks pretty serious to me. Can anyone enlighten me as to how to fix
the
SUM problem, also makes me wonder what other fundamental formulae are
now
no
longer working. Loads of business depend on Excel data, and I would
have
thought the Sum functionality pretty basic. Makes me wonder what
business
decisions are being made today on the strength of spreadsheets that
have
out
of date SUM values bearing no relation to the data that is summed by
the
SUM.
I know there was an issue with spreadsheets created in other versions
of
Office or something, but I have just created a new spreadsheet and the
SUM
does not SUM. Am I missing something here?