I did manage to catch that shortly after I posted my reply. It helps if I'm
looking at the context correctly (that you were using 'count' for non-blank
cells rather than tallying the numbers in them).

I ran in to a problem with the SUMPRODUCT on my ties where it didn't
calculate it the same on two affected teams. I'm trying to trudge through it
and figure out if I introduced an error when I transferred it to my live
multi-page workbook, but if I end up stuck, I might implore your assistance
again.

Has anyone ever mentioned that you MVPs never get the credit due? I'd have
been sunk a long time ago without some real-world intervention with Office.
:-)

beth

"T. Valko" wrote:

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



.