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