+ Reply to Thread
Results 1 to 10 of 10

Need help with working out win percentage and total wins and losses

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5

    Need help with working out win percentage and total wins and losses

    I need to have excel count the wins and losses in a column, and also work out the win percentage. However I have had to use an if statement as Im trying to make the excel document update from just one new cell

    I have a working table, where I add the new value, it works out the difference from the previous value and then displays if its a win or loss based on the result. I cannot get the wins and losses to play nice with working out a percentage and being counted for total. I've tried simple things like "=counta(B:B, win,)" for counting and "=B:B/B:B" for percentage.

    Im very new to excel and am trying to have detailed tracking of my SR changes and a Log of wins and losses for Overwatch, as the ingame analytics are not very good in this regard.

    any and all help would be appreciated


    https://drive.google.com/open?id=0B9...URta2ItanBkRFE
    Download Button is in the top right corner


    Link to download and have a look at it so far

    Thanks for any and all help.
    Last edited by AaronJB; 06-03-2017 at 05:44 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,269

    Re: Need help with working out win percentage and total wins and losses

    Attach a sample workbook (not image) on this forum please.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    06-03-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5

    Re: Need help with working out win percentage and total wins and losses

    I can't add it as an attachment when I click the option it doesn't do anything.

    I have cells setup with failed formulas in the sheet as well as the table with the data to pull

    I can post a virus scan of the drive file though if necessary

    you can download the workbook from that link it is not an image it is just the way that google drive displays it, the icon is in the top right corner
    Last edited by AaronJB; 06-03-2017 at 05:44 AM.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: Need help with working out win percentage and total wins and losses

    Welcome to the forum. Unfortunately, many members here are not able to access external file-sharing sites (company firewalls, etc), so we prefer to have file uploaded directly here but, as you've discovered, the 'attachment' icon doesn't work. Instead, to attach a file, click 'Go Advanced' below the reply box, then scroll down to find 'Manage Attachments'. Click that to upload a file.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  5. #5
    Registered User
    Join Date
    06-03-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5
    Here it is as an attachment thank you for the help
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Need help with working out win percentage and total wins and losses

    Your IF formulas have circular references and also the latter part of them will never be calculated as the result will be "win" or "loss" and stop there.
    so try:
    in B4 put
    Please Login or Register  to view this content.
    B5 and copy down
    Please Login or Register  to view this content.
    B2
    Please Login or Register  to view this content.
    F2
    Please Login or Register  to view this content.
    F1
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    06-03-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5

    Re: Need help with working out win percentage and total wins and losses

    thank you this worked perfectly. just one more thing I'd like to add.

    what formula would I use to have it work out the avg sr change

    thanks in advance

  8. #8
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Need help with working out win percentage and total wins and losses

    If you mean average of col D then AVERAGE(d4:d13)
    All formulas assume all cells to row 13 will have actual game data rather than the zeroes they have now

  9. #9
    Registered User
    Join Date
    06-03-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    5

    Re: Need help with working out win percentage and total wins and losses

    Yea I figured that out I was just being dumb thanks lol

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,269

    Re: Need help with working out win percentage and total wins and losses

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Updating wins and losses through a web query
    By Xandler in forum Excel General
    Replies: 1
    Last Post: 03-18-2017, 09:14 PM
  2. Counting Wins and Losses
    By chester1993 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2016, 09:52 PM
  3. Wins/Losses accounting for bye weeks
    By Jaded724 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2014, 10:54 PM
  4. Wins and Losses columns totalling the W's and L's?
    By shivers in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-04-2013, 09:50 PM
  5. How to turn a table of total pts into wins losses and ties
    By Bill Brasky in forum Excel General
    Replies: 1
    Last Post: 09-20-2012, 04:32 PM
  6. Excel 2007 : Count Consequtive Wins/Losses
    By jld5571 in forum Excel General
    Replies: 6
    Last Post: 11-15-2011, 09:40 PM
  7. Streak on Wins and Losses
    By palerider85 in forum Excel General
    Replies: 6
    Last Post: 10-24-2011, 01:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1