How to get average per person from the form submissions?

Martin Suchy

Hi, I've created a form and workflow to notify a specific group of persons just once new form gets submitted and all that works just perfect. I am now trying to get an average per person from all the submissions to see an overall "rating" and this is what I want to email to a specific person weekly. Can anyone advise how to handle that as I am not able to get the average per person in any summary report I've tried. Thanks a lot

Nick Brisson

Hey Martin

If I understand this correctly, if you have 10 people, giving a variety of ratings, you want their overall average rating.

If that is the case, this would work.

It adds up their total ratings, then divides by the frequency their name comes up.

If I misunderstood, please add more details and I'll try to help.

=ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 0)

Nick Brisson

Hey Martin

If I understand this correctly, if you have 10 people, giving a variety of ratings, you want their overall average rating.

If that is the case, this would work.

It adds up their total ratings, then divides by the frequency their name comes up.

If I misunderstood, please add more details and I'll try to help.

=ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 0)

Martin Suchy

Hi Nick

thanks for your reply! That helped a lot :)