Sum Wrong total but add each cell gives the correct total

[Steved]

Hello from Steved

=Sum(F23:J23) wrong Total

= F23+G23+H23+I23+J23 correct total

I find this interesting in that I know how to recify the issue but my brain
is in slowdown.

Please tell me what I need to do to use =Sum(F23:J23)

I Thankyou.

 

[Sheeloo]

This should NOT happen. I can not think of any reason for this behaviour.

Can you give the values in the cells? and the totals?

 

[Max]

This should NOT happen. I can not think of any reason for this behaviour.

Believe the OP has text numbers in some cells. SUM will just ignore text
nums, while the "+" operator will coerce any text nums to real nums, hence
giving the correct total.

For OP:Try adding a zero within the SUM range,
array-enter the formula by pressing CTRL+SHIFT+ENTER:
=Sum(F23:J23+0)
The above will coerce text nums to real nums within the range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[Steved]

Hello Max

Excellent Value I Thankyou

All the Best for 2009

 

[Sheeloo]

Thanks Max for reminding me of something I had forgotten....(that Sum ignored
Text in its range)

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Max]

No prob, Sheeloo.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik