Sadly, I cannot duplicate your erroneous result. The version of EXCEL on my
computer, unfortunately, returns 1475. Please check that your SUM function
covers all the desired inputs.
--
Gary's Student


"ראובן" wrote:

the values we 200 135 360 80 350 350
and the summay was: 1140
the first two values were not included in the Sum.
reuven

"Gary's Student" wrote:

What are the specific values that are being miss-calculated?
--
Gary's Student


"ראובן" wrote:

I'm using excel for years but today I was shocked. almost died.
While summarizing a column of numbers, the summary was incorrect.
I suspected that few cells contained text rather than numbers so I
multiplied every cell in the column and got the correct number.
So I assume that sometimes excel ignores cells and sometimes considers them.
What if the numbers are significant amounts of money? How can I rely on excel?
I will be happy to send this little sheet to you.
do i have to crosscheck every spreadsheet i use?
reuven