Sum Wrong total but add each cell gives the correct total
 

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.

Sum Wrong total but add each cell gives the correct total
 

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?

"Steved" wrote:

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.

Sum Wrong total but add each cell gives the correct total
 

"Sheeloo" wrote:
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:
Please tell me what I need to do to use =Sum(F23:J23)
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
---

Sum Wrong total but add each cell gives the correct total
 

Hello Max

Excellent Value I Thankyou

All the Best for 2009


"Max" wrote:

"Sheeloo" wrote:
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:
Please tell me what I need to do to use =Sum(F23:J23)
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
---

Sum Wrong total but add each cell gives the correct total
 

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

"Max" wrote:

"Sheeloo" wrote:
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:
Please tell me what I need to do to use =Sum(F23:J23)
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
---

Sum Wrong total but add each cell gives the correct total
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Steved" wrote in message
...
Hello Max

Excellent Value I Thankyou

All the Best for 2009

Sum Wrong total but add each cell gives the correct total
 

No prob, Sheeloo.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Thanks Max for reminding me of something I had forgotten....(that Sum
ignored
Text in its range)