SUM function adding wrong, Excel 2007

[Kathy]

"=Sum(R3:R14)" There are 3 entries in this column but 2+2 =3 every time,
adding more entries still 1 short on total. I have checked for hidden
columns/rows and there are none.

 

[Jan Karel Pieterse]

Hi Kathy,

"=Sum(R3:R14)" There are 3 entries in this column but 2+2 =3 every time,
adding more entries still 1 short on total. I have checked for hidden
columns/rows and there are none.

If you widen the column, do the numbers change? Perhaps what you see isn't what
is in the cell. Excel rounds the display of numbers if they become too wide for
a column, but it still does the math with the unrounded numbers.
Select the 2's and change the number format to show more decimal places to see
if this is correct.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jerry W. Lewis]

Another thing that could go wrong is that SUM will ignore text that looks
like a number but isn't. Does =COUNT(R3:R14) return 3?

Jerry