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 !
Bookmarks