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)

Very cool, that was exactly what I was looking for. I found the sumproduct(countifs(indirect))) somewhere else too, but couldn't make it work, probably because all the sheets are not there yet as you wrote (we are only in week 5 of the tournament). I don't fully understand the function, but it works like a charm, and that's the most important thing :-)

Where did you name the list? In my previous tries, I just had reference to the cells where the list was, this name thing seems much simpler, I could use that in other documents too :-)

And thank you very much for the help!

Ah, found it now. Thanks a lot!