Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I correct an incorrect total from a simple formula? | Excel Discussion (Misc queries) | |||
Formula total wrong | Excel Worksheet Functions | |||
My excel formula is correct, however, my total is off by .01. | Excel Worksheet Functions | |||
Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
sum of total hours not correct | Setting up and Configuration of Excel |