+ Reply to Thread
Results 1 to 3 of 3

Formula to increase number based on WINS/LOSSES or FINAL SCORE

  1. #1
    Registered User
    Join Date
    09-26-2013
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2010
    Posts
    19

    Question Formula to increase number based on WINS/LOSSES or FINAL SCORE

    There are 2 tabs in about the center of the worksheet; see RECORD (cell L4) of whichever team. Based on the RESULT/SCORE (cells F13,F19,F25,F31,F37,F43,P13,P19,P25,P31,P37,P43) where the 'W/L' are located I'd like a number to increase in the cells (L6 or N6). This will update based on the score of each game or once I place an 'L' or 'W' in the appropriate cell.

    1. What formula can be created based on the scores of each game? Depending on the tab the cell to the right of 'W/L' will be the home team and if it's possible I'd like a number to increase based on the score of a game.

    2. What formula can be created to give me this data?

    Not sure if either questions 1/2 can be answered but I wanted to ask to make it easier to update.

    Thank you,
    Tim I.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-14-2016
    Location
    New York, USA
    MS-Off Ver
    Mac 2016, Windows 2016
    Posts
    14

    Re: Formula to increase number based on WINS/LOSSES or FINAL SCORE

    If I understand the question correctly...

    In L6:
    =COUNTIF(F13:P43,"W")

    In N6:
    =COUNTIF(F13:P43,"L")

  3. #3
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Formula to increase number based on WINS/LOSSES or FINAL SCORE

    If you want to do this with both scores and "W", "L" signs then use this :
    On L6 :
    Please Login or Register  to view this content.
    On N6 :
    Please Login or Register  to view this content.

+ 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. Counting Wins and Losses
    By chester1993 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2016, 09:52 PM
  2. How to create Wins/Losses Columns
    By racefan91 in forum Excel General
    Replies: 0
    Last Post: 09-19-2013, 06:34 PM
  3. 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
  4. Is there a way to automatically work out stats based on wins and losses in a table
    By visionwindowfilms in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 04:11 PM
  5. Streak on Wins and Losses
    By palerider85 in forum Excel General
    Replies: 6
    Last Post: 10-24-2011, 01:05 AM
  6. Calculating Wins/Losses for teams
    By mracine923 in forum Excel General
    Replies: 3
    Last Post: 06-08-2011, 01:52 PM
  7. [SOLVED] How do I determine a winning % based on wins, losses, and ties?
    By rolly g in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2006, 05:45 PM

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