Thread: SUM error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary Smith Gary Smith is offline
external usenet poster
 
Posts: 3
Default SUM error

Your formula has an extra closing parenthesis which should produce an
error message, but note that

=SUM(89+90+78+71+82/5) has the value 344.4, while

=SUM(89+90+78+71+82)/5 has the value 82.

I suspect the latter is what you want.



DavidB wrote:
Can anyone tell me why this: =SUM(AI13+AW13+BI13+BW13+CJ13/5)) returns 34440%
in the destination cell when AI is 89, AW is 90, BI is 78, BW is 71 and CJ is
82??? I don't get it.


Cheers
David


--
Gary L. Smith
Columbus, Ohio