CountIF + different conditions + do not take hidden rows into account

[thomzzz]

Dears,

I'm struggling with this assignment I got at work.

If you have a look at the attachment, I have 2 tabs, "Input" where all the data is entered with a determined drop-down list from B5:O10; and a second - "global overview".

It's on the second tab that i have issues :
From A6:A24, I have all the drop-down list possibilites (same as Input Tab)
From B6:C24, I would like to have a count, condition per condition, and week per week, of what has been entered in the Input tab.

So far, If I just need to have an overview of the global picture of the input tab, I use a =COUNTIF (Input!"range";GlobalOverwiewA!"condition") which does the job.

And that's where it gets complicated : I want to the results to be changed dynamically if I filter the Input Tab (so, if I filter and select less rows, I want the count to be adapted on the global overview tab).

In other words : how do I create a formula with a CountIf where hidden rows are not taken into account ?

Thanks in advance for your help !

[igoodable]

perhaps this video can help you.
http://www.youtube.com/watch?v=vkPoViUhkxU