Thanks for the help. I have been doing the same thing for Writers, however
alot of episodes have multiple writers, and I was wondering if there was a
way to make this only look to see if the person's name is contained in the
cell, that way I would not have to create a separate entry for each group of
writers.

Thanks

"Barb Reinhardt" wrote:

=AVERAGE(IF(A1:A10="DirectorName,B1:B10))

Commit with CTRL SHIFT ENTER

A1:A10 contain the director, B1:B10 contain the ratings for each director.

I believe there is a more elegant way in Excel 2007.
--
HTH,
Barb Reinhardt



"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