I'm trying to get an average percentage per client. I attached a copy of my current sheet to give a visual of what I'm trying to do. There is a percent and to the right is a client name or abbreviation. My goal is to calculate an average for the scores in the left columns based on the clients listed in the right columns.




Thanks!

Attached Images

Capture.PNG (46.5 KB, 23 views)