Imagine the situation where 11 of your numbers are 234, with 235 being
the top and 120 the bottom (ok, unlikely, but bear with me). You would
then have 11 values of 12.9, and 1 of 13 plus 1 of 1, giving a total of
155.9, so I don't know why you think the total should be 91 points in
this case - surely you will only get that if the ranking formula
applies equal weight to the positions of the scores and not to the
scores themselves. You can do this with the RANK( ) function.

Hope this helps.

Pete