Google sheets - Multiple smart filter

Question

I am really new in Google sheets. I would like to create something simple. I have a list of hospitals and every week I take note of the number of surgical procedures that are done in each hospital.

https://docs.google.com/spreadsheets/d/1y_LYgp4yFIwglTbwtjER4ah_C3tQQ1sVZaUO_Payups/edit?usp=sharing

I would like to create 2 filters:

• Select the hospital
• Select "start week" and "end week"

and visualize the plot referred only to the resulting data coming from the filter. Is someone able to help me? Thanks so much!

Answer 1

try:

=INDEX(FILTER(B2:N13; B1:N1>=Q2; B1:N1<=Q3); MATCH(Q4; A2:A; 0))