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
Max - 26 Dec 2004 13:26 GMT
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

Signature
--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----
> In match set of five games I want to keep track of the
> wins and loses of the matches. Example; if the number
[quoted text clipped - 8 lines]
> 1/4, and 2/3, in cells v5 and v6 it would show 4 wins and
> 3 loses. Thanks
wally - 26 Dec 2004 21:04 GMT
>-----Original Message-----
>One way ..
[quoted text clipped - 32 lines]
>.
>It works great, thanks alot
Wally
Max - 26 Dec 2004 23:18 GMT
Glad it worked, Wally !
Thanks for feedback

Signature
--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----
>It works great, thanks alot
Wally
Petrus Van den Cruyce - 26 Dec 2004 15:40 GMT
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
> In match set of five games I want to keep track of the
> wins and loses of the matches. Example; if the number
[quoted text clipped - 8 lines]
> 1/4, and 2/3, in cells v5 and v6 it would show 4 wins and
> 3 loses. Thanks