AverageIf Help

Just joined the site today and looking for help in my excel database. Any help you can provide is greatly appreciated!

So I'm looking to take the average of multiple cells in different sheets but only if a different cell reads a certain name.

Cell AR3 of the sheet titled "Allen" should take the average of cell BM3 in sheets 1-17 only if cell E3 in the same sheet (1-17) reads "Allen". I'm assuming I'll need to use an AverageIf statement but not very familiar with this type of problem.

Would appreciate any help -- thanks!

-Nick

Average If does not work this way. Maybe post the file and Ill see what I can do.
Im guessing you can use a nested if, but its not going to be pretty using this method.

Same as above, if you post an example I would have a go at it for you as i'm sure others would...

Just from what you said, it sounds as though functions like SUMIF, SUMPRODUCT, COUNTIF might be useful and just divide the sum by the count in the formula rather than trying to use the AVERGARE function. It may make it easier to sum and/or count the relevant values from each sheet separately into a table on another sheet and then calculate your over all averages from that, rather than trying to refer to multiple sheets in one formula.

Brief background: This is a pitching-catching baseball statistics database. What I've done for the other stats is link Catcher's page to the pitcher for each game. If multiple pitchers in a game, it adds stats automatically. However, this is an average-based stat (on-base percentage) so I need the average all pitchers for every game.

In cell AR3 for "Allen", I need the result of the average for all previous 17 sheets' data in BM3 but only if E3 reads "Allen".

Hope this makes sense. Please let me know if I need to clarify further.

Thanks!

-Nick