Lookup and Calculate Wins and Losses from Multiple Sheets?

Hello,

I use Excel to track the scores and results for my softball league.
However, it is very easy to mis-calculate the wins and losses for any given team over the course of a season.

My sheets for each week are set up like this...

Week 1 games
week1games.gif


Week 2 games
week2games.gif

etc...

Is there any way to do a "summary" and automatically lookup and calculate the wins and losses for any given team?

I have some experience with VBA macros, if that is necessary...
I'm just hoping that someone can point me in the right direction, because this has got me stumped!

Thanks!

Not sure what you mean.

I enter the scores manually, then use conditional formatting to automatically "bold" the winning score.
However, after each week, I have to MANUALLY update the total wins and losses for each team.

I'm hoping somebody can show me a way of doing it automatically.

Thanks for your reply.