A quick one

  • Thread starter Thread starter Dark Horse
  • Start date Start date
D

Dark Horse

Down one column (E) I have:

(row 4) 3.25
(row 5) 1.67
(row 6) 5.48
(row 7) 0.00
(row 8) 2.75
(row 9) 0.00
(row 10) 0.00
(row 11) 0.00
and in the next cell beneath =sum(E4:E11)

The result is shown as 9.90, when I can readily calculate that it should be
13.15
These are direct keyboard entries, and not the results of any other
calculations - and I also get the same false result from autosum if I
highlight this group of cells.
All the 0's are zero's and not capital O's. The whole column is formatted as
number with two decimal places.
I seem to not be counting the entry in E4, as adding that 3.25 would give
the correct result - but I can't figure out why it isn't being included.
When I select that cell it is shown as E4 and as containing 3.25.
So what am I doing wrong?
 
maybe 3.25 in row 4 is formatted as text? Try entering 3.25 and check format
by right click>format
 
Hello,

I tried to duplicate your results, and the only way I
could do it was to change cell E4 to text format. Check
your worksheet. Try formatting cell E4 to a number
format, and then, press F2 (to edit the cell), and then
press enter to change the format. Simnply formatting the
cell as number format will not change it; you must then
edit the contents of the cell to have thr format change
take effect.

Bob Sullivan
springhouse
 
Dark said:
Down one column (E) I have:

(row 4) 3.25
(row 5) 1.67
(row 6) 5.48
(row 7) 0.00
(row 8) 2.75
(row 9) 0.00
(row 10) 0.00
(row 11) 0.00
and in the next cell beneath =sum(E4:E11)

The result is shown as 9.90, when I can readily calculate that it
should be
13.15
These are direct keyboard entries, and not the results of any other
calculations - and I also get the same false result from autosum if I
highlight this group of cells.
All the 0's are zero's and not capital O's. The whole column is
formatted as number with two decimal places.
I seem to not be counting the entry in E4, as adding that 3.25 would
give the correct result - but I can't figure out why it isn't being
included. When I select that cell it is shown as E4 and as containing
3.25.
So what am I doing wrong?
Click to expand...

My guess is that E4 is formatted as Text and right-aligned and thus 3.25
appears to be a value but is read as text by the SUM formula. Double-check
the format.
okg
 
As I said in my original post:
The whole column is formatted as number with two decimal places.
 
that fixed it, but other cells - dependent on the result of that number
accepted it as a number with no problem. Weird
 
Back
Top