I need to collect the average of a column by referencing name in another column
I have columns in a sheet per the screen below. The Team Member is input through a form submission and can potentially be input many times. I am looking for a formula to collect the average score from all rows where one name appears without having to say ="Scooby Doo".
Help Article Resources
Check out the Formula Handbook template!