+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Wins/Lose & PF/PA tracker

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    Belgium
    MS-Off Ver
    2007
    Posts
    14

    Wins/Lose & PF/PA tracker

    I have a excel sheet with a team schedule on it with the teams bouncing back and forth between home and away. Is there a way to tally wins and losses for them auto based on the entering of the scores? I can set up the position column based on the rest. I really just need help with the formula to get it going. I also am trying to calculate points for and points against if that is possible too. I am assuming it would be similar to the formula for wins/lose columns. All the real info is in the attached doc.
    Attached Files Attached Files

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Wins/Lose & PF/PA tracker

    One way:
    In H2 and copied down: =IF(G2="","",IF(E2>G2,"H","A")) this helper column can be hidden or just formatted as white font
    In K2: =SUM(COUNTIFS(D:D,I2,H:H,"H"),COUNTIFS(F:F,I2,H:H,"A"))
    In L2: =SUM(COUNTIFS(D:D,I2,E:E,"<>"),COUNTIFS(F:F,I2,G:G,"<>"))-K2
    In M2: =SUM(SUMIF(D:D,I2,E:E),SUMIF(F:F,I2,G:G))
    In N2: =SUM(SUMIF(D:D,I2,G:G),SUMIF(F:F,I2,E:E))
    Select K2:N2 and copy down

    BTW - Detroit's team is the Tigers (not Tigars)

+ 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