Incrementing values based on comparison

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
rccruiser said:
I have a spreadsheet I use for tracking scores in a league. Among other
Click to expand...
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
Click to expand...
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.
 
Back
Top