"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
---