Assuming you have set up and populated the sheets on your computer and named
each sheet with a name like Game1, Game2, etc. and the layout is identiical
on each sheet

And the sheets are next to each other sequentially, in another sheet, the
summary sheet, you can use formulas like

=sum(Game1:Game7!B2) in this case in B2 of the summary sheet. You could
drag fill this down and across.

There are just a few functions that support this 3D notation. Sum and
Average are two.

--
Regards,
Tom Ogilvy


"Coach Mike Wyatt" wrote in message
...


i am trying to go back and put stats from 7 previous teams on my
computer

what i am going to do is have a sheet that will have season totals and
then one sheet for each game

i will have a header season totals or carter vs farragut at the top

then i will have a column (going right to left that says players,
2pointers, 3 pointers, free throws attempted, free throws made, points
and averages.

then i will have under players a list of the players from my team.
at the bottom under the last player i will will have a column for team
total.

please email me at and carbon copy it to me at