Try this | Message 4 of 7 | TechRepublic

Discussion on:

Compute your entire Excel worksheet with a click of the mouse

View entire thread

Message 4 of 7

Next » « Prev

0 Votes

+ -

Try this

Assume your values to average are in A1:A7

The formula would be

=(MOD(SUM(A1:A7),360)/COUNT(A1:A7))

Posted by LocoLobo

11th Mar 2008