View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2

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?