For Tiger (scores in the range B2:J2):

=SUMPRODUCT(--(B2:J2<B4:J4))

For Rory (scores in the range B4:J4):

=SUMPRODUCT(--(B4:J4<B2:J2))

Biff

"Jamie W" <Jamie wrote in message
...
Hi All,

Here's my problem in a nutshell. I have rows of values, and I want to
count
the number of cells where Row A's value is less than Row B's value. (It's
basically a match spreadsheet calculating number of holes won per player
in
match format.) Cumulative difference of the row ranges won't help. Any
ideas? I don't think COUNTIF will support this, but I'm sure there's got
to
be a way.

Here's a visual:

Scores Holes Won
Tiger Woods 5 3 4 5 4 2 4 4 4 X

Rory Sabbatini 4 4 4 5 3 4 4 3 4 X

Thanks,

Jamie