View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default 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.