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.

[TABLE="width: 400"]
<tbody>[TR]
[TD]Quarter:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Location:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Function:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Agree[/TD]
[TD]Disagree[/TD]
[TD]Neutral[/TD]
[/TR]
[TR]
[TD]Q1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Q2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Q3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]