Results 1 to 5 of 5

Counting with multiple criterias across multiple sheets

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    24

    Counting with multiple criterias across multiple sheets

    Hi, I hope someone can help me as I'm not very experienced with Excel...

    I'm doing some statistics on penalties called in football games, to help evaluate the officials. To do that I have an Excel document with a few sheets for the statistics and then a sheet for each game (called Sheet1-Sheet59)

    - In each "game sheet" the penalties is in columns D and F
    - In each "game sheet" the grades for each penalty is in columns E and G
    - Each penalty can be graded as CC, MC, IC or NG

    What I'd like to do is count (for each type of penalty) the number of CC's, MC's and so on for the entire season. The only way I've come up with so far is something like (for FST in this example):

    =COUNTIFS(Sheet1!D:D;"FST";Sheet1!E:E;"CC")+COUNTIFS(Sheet1!F:F;"FST";Sheet1!G:G;"CC")+COUNTIFS(Sheet2!D:D;"FST";Sheet2!E:E;"CC")+COUNTIFS(Sheet2!F:F;"FST";Sheet2!G:G;"CC")+[and so on - this is gonna be a lot of text with 59 sheets... and that's just one grade of one penalty...]

    Isn't there an easier way to collect that information? This would have to be done for 86 different penalties and each get one of four different grades...

    I don't know if I can explain it properly, so I attached the document as it is now (far from finished), maybe it's easier to understand with that (or maybe it's harder if I didn't do it very well...) (and some of the text is in Danish I'm afraid)
    Attached Files Attached Files

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