Formula to track wins/loses

[WallyB]

In match set of five games I want to keep track of the
wins and loses of the matches. Example; if the number
entered in cell b5 is greater than the number entered in
b6 then a 1 (for one win) is entered in cell v5. If not,
then a 1 (for one lose) is entered in cell v6. This
scenerio would be repeated in ajoining cells as the
matches progress. I.e., next match would be entered in
b6 & c6, b7 & c7, etc. The numbers in cells v5 & v6 are
cummulative. So, if a person won 4 matches with scores of
3/2, 4/1, 3/2, 3/2 and lost 3 matches with scores of 2/3,
1/4, and 2/3, in cells v5 and v6 it would show 4 wins and
3 loses. Thanks

 

[Petrus Van den Cruyce]

I believe a possible solution for you is the following:

take a colum for instance colum t

in that colum you insert the formula if (b5>c5;1;0)
in the colum u you insert the formula if (b5<c5;1;0)

In cell v5 you put the sum of the elements in colum t
in cell v6 you put the sum of the elements in colum u

I believe this is an answer to your question.

Greetings from Brussel Belgium

 

[wally]

-----Original Message-----
One way ..

Assume scores will be entered in the range B5:C11,
in paired sequence down, viz:
in B5:C5, then B6:C6, ... B11:C11

Try:

In V5: =SUMPRODUCT(--($B$5:$B$11>$C$5:$C$11))
In V6: =SUMPRODUCT(--($B$5:$B$11<$C$5:$C$11))

Adapt the ranges to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----



.
It works great, thanks alot

Wally

 

[Max]

Glad it worked, Wally !
Thanks for feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

It works great, thanks alot

Wally