Formulas based on values in multiple drop down lists

[TROH3178]

What I'm looking to do is have my "sumif" formulas update based on values selected in different drop down lists. For example, when Q1-2018 is selected, it'll populate the responses that were Q1-2018. Then, I'd like to further isolate the data by a location, and then have a 3rd option. I can make it work by having all 3 options selected, but would like to be able to do them independently. Hope that makes sense!

Thanks!

 

[RasGhul]

Hi Troh,

Can you post some sample data so we can come up with a solution for you.

 

[TROH3178]

Hi! I'm not sure how to get sample data posted, but here is the formula in the cells:
=COUNTIFS(Raw!$D$2:$D$200, Summary!B$6, Raw!$H$2:$H$200, Summary!$B$1, Raw!$B$2:$B$200, Summary!$B$2, Raw!$C$2:$C$200, Summary!$B$3)

B1, B2, and B3 are the values in the drop down fields.

Quarter:
Location:
Function:
	Agree	Disagree	Neutral
Q1
Q2
Q3

<tbody>
</tbody>