Average for multiple entries

[kd93]

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

[ve3oat]

I think you have answered your own question. You grouped the ratings by freelancer and then calculated the average for each. So in your spreadsheet you could have one row for each freelancer with the different ratings for him or her in cells on the same row. Then calculate the average for each of them at the end of each row. =AVERAGE(A2:A10) and =AVERAGE(B2:B10) for example. Just a suggestion.

[kd93]

One important thing I forgot to mention - these are ratings for each task each freelancer has performed. And since there are constantly new tasks being performed the ratings are dynamic.

[Regina]

That is a typical task for a pivot table. The column header of the freelancer name goes to Row Fields and the column header of the rating goes to Data Fields. The default function in the Data Fields are is ‘sum’, but when you double-click on it, you can change it to ‘average’. If you make the source range much larger as you currently need it, you can add further data and get the updated results with the ‘Refresh’ from context menu of the Pivot Table.