In column A I have the freelancers’ names, in column B their ratings. These are ratings for each task each freelancer has performed. For example John has performed 3 tasks so far - one task got a rating of 5, the other a rating of 2, and the third a rating of 1, for an avg. of 2.66. And since there are constantly new tasks being performed the averages are constantly changing.

I’d like to get the average rating for each freelancer.

John 5

Jane 3

Tim 5

Sarah 1

John 2

Jane 5

Tim 3

Sarah 2

John 1

Jane 2

Tim 1

Sarah 4

Averages:

Tim: Sum 9 - Avg 3

Sarah: Sum 7 - Avg 2.33

John: Sum 8 - Avg 2.66

Jane: Sum 10 - Avg 3.33