If you have a 20 game season with, say, 10 home games and 10 road games you
might be able to simplify your life if you kept each home game on a separate
sheet with sheet names such as HOME1, HOME2 .... HOME10 and the road games
on separate sheets with with sheets names such as ROAD1, ROAD2 .... ROAD10.
If all the home games are grouped together followed by the road games, on
your last sheet, SUMMARY, you can simply average a cell such as A1 on each
sheet with something like:

=AVERAGE(HOME1:HOME10!A1) for the home games or
=AVERAGE(ROAD1:ROAD10!A1) for the road games or
=AVERAGE(HOME1:ROAD10!A1) for all the games.

Also you can easily print your sheets, one for each game

Just be certain the the first home game sheet is HOME1 and the last home
game sheet is HOME10 and the other home game sheets are located between
HOME1 and HOME10 in the workbook. Same for the road games.

Tyro


"DougN" wrote in message
...
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.