Results 1 to 3 of 3

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

Threaded View

  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

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. 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