+ Reply to Thread
Results 1 to 4 of 4

Calculating Wins/Losses for teams

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Boston
    MS-Off Ver
    Excel 2003
    Posts
    2

    Calculating Wins/Losses for teams

    I'm building a spreadsheet for our athletic department that allows coaches to enter individual game data in a form that gets dumped into a spreadsheet. I know this is easy, but I can’t figure out the right formula to calculate the number of wins and losses for each team! I have a spreadsheet with various game results that look like this...

    Team Result
    New York Win
    Miami Loss
    Boston Win
    New York Win

    I want to have another sheet that counts the number of times “Win” appears in column B for just New York and the same for each team. Could you point me towards the formula to use?

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Calculating Wins/Losses for teams

    mracine923,

    I created an example spreadsheet using your example information. The formula was entered with CTRL+SHIFT+ENTER.

    Hope this helps,
    ~tigeravatar
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-08-2011
    Location
    Boston
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Calculating Wins/Losses for teams

    Amazing! I never expected an answer that fast with an example spreadsheet! I was playing around with that formula but you made it work. THANK YOU!!!

  4. #4
    Registered User
    Join Date
    10-01-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Calculating Wins/Losses for teams

    You can also use the "countifs" formula... see attached. I put everything in one worksheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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