Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2
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?
|