I don't think the."IF(COUNT(C3,F3)<2,"",..."
portion will work, because it's always feasible
that someone could have a 1-0 game.

That portion is only testing that scores have been entered for both teams.
The formula won't calculate the winner or loser until 2 scores have been
entered.

--
Biff
Microsoft Excel MVP


"BethP" wrote in message
...
Thanks so much for the reply Biff.

For the winner/loser formulas, I don't think the
"IF(COUNT(C3,F3)<2,"",..."
portion will work, because it's always feasible that someone could have a
1-0
game. (It's senior softball with a 240 foot fence, so not likely, but...)

The "tie" formula worked perfect. I still haven't been able to wrap my
head
around the myriad uses of the SUMPRODUCT formula, but it sure seems to
work
wonders.

And you're right, I am using 2007. However, I forgot that the SUMIFS was
new to 2007. I'll have to make sure I can keep that in here, as I don't
know
if all of our scorekeepers are running 2k7 or 2k3. (I just finally
upgraded
about a month ago) If so, I'll definitely play with the IFERROR funtion,
as
that will be much cleaner than the extended IF(ISERR(... mess is.

(I use IF(ISERR(... with VLOOKUP *all* the time, and it make for some
awfully large clunky formulas.)

Thanks again!
beth