One more quick question, is it possible to show how many episodes that person
directed. (Basically, counting how many ratings were averaged.)

Thanks for all the help!

"prattmic" wrote:

I am creating a spreadsheet for one of my favorite shows that includes
director name and rating for each episode. What I want to do is show the
average episode score for each director. In a sense it needs to find each
row with a certain directors name in the director column, then grab each
episode rating from the director's episodes and average them.

I hope this makes sense.

Thanks