+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Help making my sheet count one column only if criteria from another column is true

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Smiths Station, AL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help making my sheet count one column only if criteria from another column is true

    I appologize if this is a simple fix but I've tried a few different functions and for some reason I cannot seem to wrap my brain around this one.

    I am attempting to create a spreadhseet where the user picks Wins and Losses of each game for the football team. In Column A it lists the OPPONENT and in Column C it lists the RESULT (user-input). I've got the Wins and Losses couting at the bottom by using the COUNTIF function (=COUNTIF(C8:C20,"win"). Now I need to count the number of wins and losses ONLY IF its is a conference game to return each teams conference record. So I need the formula to take the same COUNTIF function used to calculate wins and losses, but to somehow recognize only the twelve conference teams and return the numbers of wins and losses IF its one of the conference teams. I can attached what I have thus far if needed. Thanks in advance for the help!

  2. #2
    Registered User
    Join Date
    06-21-2012
    Location
    Smiths Station, AL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help making my sheet count one column only if criteria from another column is true

    I got it figured out. Just did a SUM of COUNTIFS for each team in the conference to calculate the WIN total and the same for the LOSS total. It's a pretty long formula since you have to do 14 seperate COUNTIFS (one for each team in the conference), so if anyone has an easier solution, feel free to share. Thanks.

+ 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