Discussion on:

Compute your entire Excel worksheet with a click of the mouse

A pernnial issue - how can you achieve vector averaging (sometimes called geometric averaging etc) to average Wind Direction data, where an arithmetic average for wind directions of 350 degs and 10 degs gives the totally incorrect result of 180 degs.

set up a formula where if the difference between the angles is greater than 180? then add 360 to the larger angle? Then use a mod function to put it back to 1-360??

I don't think this can be done in a formula in 1 cell. So have a cell that calculates the range. Then next to your raw values transform the value more than 180? lower than the max. Then average and transform back to 1-360?.

Maybe someone else has an elegant solution. I would be interested too.

No idea what your going on about.

I'll move on.

Sorry.

Assume your values to average are in A1:A7

The formula would be

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

For seven values between 310 and 360, your formula yields a result of 26-something. If you go past 360 to 5 or 10, the result increases to 45.

Somehow, I don't think that's correct.

Would like to know where this is going