Excel formula for returning AVG points / match of player in tournment

Started by Benzadeus, July 28, 2009, 05:56:37 PM

Previous topic - Next topic

Benzadeus

1 - Export spreadsheet to Excel format.
2 - At range BK2, enter formula =SUM(IF(ISERROR(MID(C2:BJ2,1,2)-MID(C2:BJ2,5,2)),"",MID(C2:BJ2,1,2)-MID(C2:BJ2,5,2)))/COUNTA(C2:BJ2) and press SHIFT+CTRL+ENTER.
3 - Copy the formula until range BK51.

Now you have AVG points per match of all players.

Blink

thanks for the suggestion and directions on how to add it in benzadeus, i'll put it in later.  Actually - an easier way of calculating this is by simply dividing the total points on page 3 by total games played.