| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adds ok but try to sum() returns 0
Hello from Steved
=J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
Try entering it as:
=SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
Hello Laura.
I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0 Steved "Laura Cook" wrote: Try entering it as: =SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
I reckon it's text SteveD. Try this, it should verify this
=SUM(--J79:J82) as an array formula, so commit with Ctrl-Shift-Enter, not just Enter -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Steved" wrote in message ... Hello Laura. I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0 Steved "Laura Cook" wrote: Try entering it as: =SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
Hello Bob from Steved
I did do a =SUM(--J79:J82) but did not use as a array Formula. I thankyou. "Bob Phillips" wrote: I reckon it's text SteveD. Try this, it should verify this =SUM(--J79:J82) as an array formula, so commit with Ctrl-Shift-Enter, not just Enter -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Steved" wrote in message ... Hello Laura. I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0 Steved "Laura Cook" wrote: Try entering it as: =SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
Really? How did you do that?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Steved" wrote in message ... Hello Bob from Steved I did do a =SUM(--J79:J82) but did not use as a array Formula. I thankyou. "Bob Phillips" wrote: I reckon it's text SteveD. Try this, it should verify this =SUM(--J79:J82) as an array formula, so commit with Ctrl-Shift-Enter, not just Enter -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Steved" wrote in message ... Hello Laura. I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0 Steved "Laura Cook" wrote: Try entering it as: =SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adds ok but try to sum() returns 0
I would guess that your cells contain not numbers but text.
=J82+J81+J80+J79 will cope with that, but SUM() won't. Change the text entries to numbers. -- David Biddulph "Steved" wrote in message ... Hello Laura. I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0 Steved "Laura Cook" wrote: Try entering it as: =SUM(J79:J82) -- Laura Cook Neenah, WI "Steved" wrote in message ... Hello from Steved =J82+J81+J80+J79 is ok =SUM(J82:J79) returns 0 The Cells format is General, I changed it to number and it still does not work. Thanks for looking at my issue. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down that returns to the last selection and can be formated. | Excel Discussion (Misc queries) | |||
| cell returns wrong value | Excel Worksheet Functions | |||
| SUM returns #VALUE! error | Excel Worksheet Functions | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
