Excel not always summing correctly



I have a cell (k3) with this formula: =sum(h3:j3). The sum is not correct;
however, when I enter in K3 this formula, =h3+i3+j3, it works. Is this a bug
in Excel? (I'm using Excel 2003.)

Bernie Deitrick

SUM will only sum actual numbers, while the = + + construction will convert any strings that look
like numbers into numbers prior to adding.

So, my guess is that one of your "numbers" is actually a string, either entered in a cell that was
formatted as text, returned as a string from a formula, or entered with a leading single quote.

You can change the SUM formula to


entered using Ctrl-Shift-Enter, or use


MS Excel MVP

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