I am using Excel 2003.

I am a basketball coach looking to create an effeciency chart for my
players. What I have so far is a seperate sheet for all of our games. There
is a row for each player and columns for each stat. The last column is their
Effeciency Rating for that particular game that is calculate by a formula I
created.

Also on each sheet (one sheet per game remember) I have a box that indicates
whether the game was at home or on the road. I would like to be able to make
a formula for my last sheet that will be able to average ONLY the home games
and then another that would average their rating for ONLY the road games. So,
in my logic it would be "IF LocationCell = H, then average the rating" or "IF
LocationCell is R, then average the rating"

I hope this makes sense- thanks for your help.