Hi David,

Your problems are possibly these.

First, the resulting display of 34440% is a formatting issue. To go back to
displaying a regular number you need to click on the Format menu, select
Cells and make sure the Number tab is selected. Click on General at the top
of the list on the left and click OK.

Second the calculation. A mathematical order of operations governs the way
in which your formula is evaluated:
=AI13+AW13+BI13+BW13+CJ13/5 will mean that CJ13/5 is calculated first
followed by the addition of the other cell references, whereas:
=(AI13+AW13+BI13+BW13+CJ13)/5 will ensure that all addition is completed
prior to the total being divided by 5.


--
Hope this helps,
MarkN


"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