SUM function adding wrong, Excel 2007

  • Thread starter Thread starter Kathy
  • Start date Start date
K

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.
 
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
 
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
 
Back
Top