Slicer and Countifs?

[thp510]

I have a list of people that show up based on some slicers that I'm using in a Pivot Table on worksheet called "Tally"

For example, here's the result of the pivot on worksheet "Tally" if I select "USA" on the slicer

Region Slicer: USA

	A	B	C
1	Julie
2	Max
3	Tom
4	Suzie
5	Bill
6
7	Sports Total

Here's the result of the pivot on worksheet "Results" if I select "EMEA" on the slicer
Region Slicer: EMEA

	A	B	C
1	Gus
2	Tobin
3	Chloe
4	Karl
5
6
7	Sports Total

Now I also have another separate worksheet called "Raw Data" that shows every employee worldwide (over 1,000 rows) with their Hobby Choice, Food Choice, etc... across the columns.

	A	B	C	D
1	Name	Region	Hobby Choice	Food Choice
2	Karl	EMEA	Sports	Pizza
3	Tom	USA	Sports	Soup
4	Li	APAC	Sports	Pizza
5	Chloe	EMEA	Sports	Cheeseburger
6	Bill	USA	Sports	Cheeseburger
7	Max	USA	Eating	Pizza
8	Janson	LATAM	Sports	Pizza
9	Karl	EMEA	Sports	Pizza

Going back to the "Tally Worksheet", I'd like to populate the cell in B7 with the right total of individuals that picked "Sports" based on the slicer that shows up. For example, if I picked the region USA on the slicer, I would only see people in the USA. That means I want to calculate the total number of folks that picked Sports as their hobby but are also in the USA. That number should populate in cell B7. For example the below would show this:

Region Slicer: USA

	A	B	C
1	Julie
2	Max
3	Tom
4	Suzie
5	Bill
6
7	Sports Total	2

If the slicer picked EMEA then EMEA folks would only populate and the sports total in B7 would be 3.

Region Slicer: EMEA

	A	B	C
1	Gus
2	Tobin
3	Chloe
4	Karl
5
6
7	Sports Total	3

Does anyone know what would be the formula that I would need to put into cell B7?

Thank you!​