I do something similar during the NFL season.

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"))))

These may be a bit better:

Winner
=IF(COUNT(C3,F3)<2,"",IF(C3F3,B3,IF(F3C3,E3,"Tie ")))

Loser
=IF(H3="","",IF(C3=F3,"Tie",IF(H3=B3,E3,B3)))

with the ties, I can't figure out how to grant
each team that played 1 point there

=SUMPRODUCT(((B$3:B$10=B18)*(H$3:H$10="tie"))+((E$ 3:E$10=B18)*(I$3:I$10="tie")))

Pct:
=IF(ISERR(SUM(C18+E18*0.5)/SUM(C18:E18)),"0",(SUM(C18+E18*0.5)/SUM(C18:E18)))

Not sure how your data is setup but this is the formula I use for getting
the winning %.

Whe

B2 = wins
C2 = loses
D2 = ties

=IF(SUM(B2:D2),ROUND((B2+D2/2)/SUM(B2:D2),3),0)

I round the result to 3 decimal places then I use a custom number format of
..000 so that the leading 0 isn't displayed. For example: .667 vs 0.667.

I see you're using Excel 2007:

Runs scored: =SUMIFS

So, you can eliminate the If(ISERROR junk with:

=IF(ISERR(SUM(C18+E18*0.5)/SUM(C18:E18)),"0",(SUM(C18+E18*0.5)/SUM(C18:E18)))

=IFERROR(SUM(C18+E18*0.5)/SUM(C18:E18),0)

--
Biff
Microsoft Excel MVP


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