Count Unique Values with Multiple Criteria

[Country_Calc]

I need a formula that will count unique values with multiple columns (at least 3) of text criteria.

Here is my summary table

Country	Unique Finance people with Industry Experience in United States
United States	2 [Need formula here]

Raw Data (assume on different worksheet in same document)

Employee Name	Country	Experience	DEPARTMENT
Jones, Mike	UNITED STATES	INDUSTRY	FINANCE
Jones, Mike	UNITED STATES	INDUSTRY	FINANCE
Smith, Adam	UNITED STATES	RETAIL	FINANCE
Palo, Sara	UNITED STATES	INDUSTRY	FINANCE

 

[Peter_SSs]

You should be able to adapt this to data on another sheet.

22 03 24.xlsm
	A	B	C	D
1	Here is my summary table
2
3	Country	Unique Finance people with Industry Experience in United States
4	United States	2
5
6	Raw Data (assume on different worksheet in same document)
7
8	Employee Name	Country	Experience	DEPARTMENT
9	Jones, Mike	UNITED STATES	INDUSTRY	FINANCE
10	Jones, Mike	UNITED STATES	INDUSTRY	FINANCE
11	Smith, Adam	UNITED STATES	RETAIL	FINANCE
12	Palo, Sara	UNITED STATES	INDUSTRY	FINANCE
Count Unique

Cell Formulas
Range	Formula
B4	B4	=IFNA(ROWS(UNIQUE(FILTER(A9:A12,(B9:B12=A4)*(C9:C12="Industry")*(D9:D12="Finance"),NA()))),0)

 

[Country_Calc]

Thank you so much for this!!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.