+ Reply to Thread
Results 1 to 5 of 5

Count Matches, Not Games

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Count Matches, Not Games

    I have a spreadsheet that is used to track stats during a tournament. In the past we have always used a number of games as the minimum before a team's rating can change. We would like to change it so it's a minimum number of matches instead. A match can be as few as 2 games and (currently) as many as 7 games. If you look at the sample spreadsheet I've attached, the match data starts in column J. I've marked the top of the sheet to delineate matches but I'm not sure how the count the number of unique matches. The formula should be (for the first team) in E5. I've filled in that cell for the three examples. Any help would be greatly appreciated.
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Count Matches, Not Games

    Hi

    Try this one.
    E5
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy down each teams.

    Regard
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Count Matches, Not Games

    It seems to work, but is only counting games (for the first team as an example) in row 6. It needs to check both row 5 and 6 as not all teams will have stats in each match for both types of games. Is that possible?

  4. #4
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Count Matches, Not Games

    Hi

    Formula I gave you work for matches only, not game?
    Countif every 5 columns as count 1, once you put the score in 1 or more up to 5 each matches. Sorry this only count 1 row 6, not both row 5 and 6. I try nothing work? Unless someone out there can crack it or not?

    To countif a games instead as matches is this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This can count both row 5 and 6.

    Regard

  5. #5
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Count Matches, Not Games

    Neither of these solutions will work for me as I need to count matches (not games) and a match can consist of both types of games or just one (or the other) so it needs to look at both row 5 and 6 (in the case of the first team). I need to have this working by the 12th so I guess I will start looking for another approach.

    Thanks for trying!

+ 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. Replies: 10
    Last Post: 08-07-2017, 01:33 PM
  2. last 6 games form in soccer matches,suitable formula
    By davide2574 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-23-2014, 06:03 AM
  3. [SOLVED] Count number of occurrences but if there are consecutive matches count them as one
    By michaljireht in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-26-2013, 08:26 PM
  4. Count games played
    By geminiviper in forum Excel General
    Replies: 68
    Last Post: 10-20-2011, 11:00 AM
  5. [SOLVED] COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.
    By witchcat98 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2005, 10:06 AM

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