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
|