Hi Vijay_India,

I have now just created a brand new clean spreadsheet and all I have done is
type
1
into A2

and the formula =SUM(A:A) into B1 cell

B1 shows 0

I have even set the format for the entire worksheet to Number 2 decimal places
A2 shows 1.00
B1 shows 0.00

Even inserting =A2 into C1 shows
0.00 in C1 cell

Thanks for your advice, looks like something pretty fundamental.

"Vijay_India" wrote:

Check the numbers in the column through selecting the cells one by one while
noticing the sum figure on the status bar. this might give you a clue on the
cells that are not affecting the total.

"knowq.biz/video.htm" wrote:

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?