Incrementing values based on comparison

[Guest]

I have a spreadsheet I use for tracking scores in a league. Among other things, the spreadsheet contains two columns of scores, one for each opponent. Right now, I'm manually tracking wins and losses, but I'd like to automate it. As an example, let's say column A contains scores for player A and column B contains scores for player B. I want to create a formula that compares the values in each row of the columns and increments the appropriate value in wins or losses

Example

ROW#
1 COL. A COL.
2 157 16
3 214 25
4 180 17

Based on the above, the record for player B should be 2-1 and player A should be 1-2. So, in fow 2, for example, if B2>A2, then increment another cell by 1 in the win column. Otherwise, put it in the loss coumn.

Thanks in advance for any suggestions.

 

[Don Guillett]

This is an array formula so it must be entered/edited with CSE
(control+Shift+enter)

=COUNTIF($K$11:$K$13,">"& $J$11:$J$13)

--
Don Guillett
SalesAid Software
(e-mail address removed)

I have a spreadsheet I use for tracking scores in a league. Among other

things, the spreadsheet contains two columns of scores, one for each
opponent. Right now, I'm manually tracking wins and losses, but I'd like to
automate it. As an example, let's say column A contains scores for player A
and column B contains scores for player B. I want to create a formula that
compares the values in each row of the columns and increments the
appropriate value in wins or losses.

Example:

ROW#
1 COL. A COL. B
2 157 161
3 214 254
4 180 179

Based on the above, the record for player B should be 2-1 and player A

should be 1-2. So, in fow 2, for example, if B2>A2, then increment another
cell by 1 in the win column. Otherwise, put it in the loss coumn.