Ask Your Question
0

Average for multiple entries

asked 2018-08-06 17:04:13 +0200

kd93 gravatar image

updated 2018-08-06 19:30:25 +0200

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

edit retag flag offensive close merge delete

Comments

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.

ve3oat gravatar imageve3oat ( 2018-08-06 18:32:07 +0200 )edit

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.

kd93 gravatar imagekd93 ( 2018-08-06 19:28:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-06 21:57:56 +0200

Regina gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-06 17:04:13 +0200

Seen: 276 times

Last updated: Aug 06 '18