Hi all,

I'm stuck on a project and am hoping someone can give me a little insight.
I may be taking a long and onerous way around what I'm trying to accomplish
in the first place, so feel free to re-direct me.

I have a few existing spreadsheets that I'm trying to make easier to manage.
Our softball league records scores in to the schedule page, and I would like
to standings page to update automatically from there. This is what it looks
like so far:

Scores pg (this table starts in cell B2):
Home Score Visitors Score
A 13 vs. B 5
B 7 vs. A 15
C 3 vs. D 10
D 17 vs. C 17
D 23 vs. B 23
B 4 vs. D 14
A 9 vs. C 12
C 16 vs. A 15

On that page, I hid a few columns to lookup who actually won each game. I
couldn't come up with an easy way to lookup who won just off of the scores,
so I figured this would be the easiest way to write my count formulas. It
looks like this, with these formulas in each cell (starting in H2, next to
the scores):

Winner Loser
A B
A B
D C
tie tie
tie tie
D B
C A
C A

Formulas: Winner IF(ISBLANK(C3),"",IF(C3-F30,B3,(IF(C3-F3<0,E3,"tie"))))
Loser IF(ISBLANK(C3),"",IF(C3-F3<0,B3,(IF(C3-F30,E3,"tie"))))

So on my standings page, I have this table. I calculated the wins and
losses based off those hidden columns, but with the ties, I can't figure out
how to grant each team that played 1 point there. My table and the formulas
so far (on my test page, this table starts in B17):

TEAM WON LOST TIE PCT PTS RS RA
A 2 0 1.000 4 28 12
B 0 2 0.000 0 12 28
C 2 1 0.667 4 20 27
D 1 0 1.000 2 27 20

Formulas Won tally: =COUNTIF(H3:H6,B18)
Lost tally: =COUNTIF(I3:I6,B18)
Tie tally: =??
Pct:
=IF(ISERR(SUM(C18+E18*0.5)/SUM(C18:E18)),"0",(SUM(C18+E18*0.5)/SUM(C18:E18)))
Points: =SUM(C18*2+E18)
Runs scored: =SUMIFS($C$3:$C$6,$B$3:$B$6,B18)+SUMIFS($F$3:$F$6, $E$3:$E$6,B18)
Runs against:
=SUMIFS($C$3:$C$6,$E$3:$E$6,B18)+SUMIFS($F$3:$F$6, $B$3:$B$6,B18)

I have all of the error nullification in there to prevent cluttering up the
page with games that have not played yet.

So does it look like I'm missing something easy, making more work for myself
somewhere, or completely in over my head?

Thanks a bunch!
-beth