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.)
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.)
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
=SUM(H3:J3*1)
entered using Ctrl-Shift-Enter, or use
=SUMPRODUCT(H3:J3*1)
HTH,
Bernie
MS Excel MVP
"Watercolor artist" <[email protected]> wrote in message
news:[email protected]...
>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.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks