I'm putting together a sheet that ranks a bunch of gamers based on their
stats. The ranking will be done once per week. After each ranking, I'm
listing how much the rank changed since the previous ranking. So, I have a
column of numbers which include both positive and negatives. The Sum and
the Average of this column is always going to be zero, but I want to show
the average change in absolute terms. I.e. the average player moved 2.5
ranks this week (whether up or down the ranks).

I'm thinking AVERAGE(ABS(A:A)) but it doesn't calculate correctly. For this
sample data:

1
-1
2
-2
3
-3
4
-4

That formula calculates "4" but it should be "2.5"


--
Marc.