Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2004

Tip: Looking for answers? Try searching our database.

Formula to track wins/loses

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
WallyB - 26 Dec 2004 12:30 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.