SUM function adding wrong, Excel 2007

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.
 
J

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top