Running numerous countifs for formulas - stuck on best way to setup/apply filters 2 recalc

Excel file attached. Using Office 365.

I have a number of easy countif formulas setup that grab the counts given the various criteria across a number of columns. Ultimately, this is to create a percentage calculation where I use the countifs to sum all the numerator values and then another sum to have all the various denominator values and then create that percentage. That is easy enough - I'm sure there is a better way to do it, but it's simple and easy to replicate.

My problem is I have to do this same countif/sum/division for 23 different scenarios based on filtering the data source various ways. It also has to be repeatable as I have to do this every month where I copy a new datasource into the Excel file to run the various calculations.

I've seen other scenarios on here around not counting hidden rows where you create a visible flag and use sumproduct formulas, but that doesn't seem like it would work given how many filters I need to apply. Any help?

Thanks! I updated the formulas a bit for the calculations to be correct. I verified that the Market Num selection list works as well as the Q5 list with your 1/2/3/1-3 drop down list but how would I change that to update for running Q14 or Q56?

Go to Data ==>Data Validation==>Allow: List Source: Q14_List

Repeat and use Q56_List

Got it. I didn't see the formula edits I needed to make to pick the correct column (B/C/D for the change in Q14/Q56/Q6). That's all sorted now.
Here was the final worksheet for posterity with all the updates made.

If you are happy with the solution offered would you please mark the thread as SOLVED: see "Thread Tools" at top of first post.

Thank you.

So, reviewing this closer, the solution was to instead use =countifs to add the additional filter based on the additional logic needed for each of those 23 data filter scenarios. You cleaned it up a bit by adding data validation so instead of 23 calculation sections, we could get down to just 6 or so by using the data validation list. Got it! thanks for the help!