Average for group of people in different divisions

Hi all, I'm hoping somebody can help with this? I need an average score for each person, in each of the different divsions they compete in Sample table below Player 1 when competing in yellow divi...