Formula for Distinct text values based on other criteria

[esmarques]

Hello,
I am trying to find how to show the number of distinct Artists and Staff in the file attached. I have manage to find the distinct number of people as a whole but coudn't do it when try to add fiuther criterias to find out the number of distinct staff or artist.
Any help is welcomed.

Number of distinct people.xlsx
	A	B	C
1	name	artist	staff
2	Mike	TRUE
3	John		TRUE
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12
13
14
15	Distinct People	5
16	Distinct Artists		(should be 2)
17	Distinct Staff		(should be 3)
Sheet1

Cell Formulas
Range	Formula
B15	B15	=SUM(IF(ISTEXT(A2:A11),1/ COUNTIF(A2:A11,A2:A11),””))

Thank you

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	name	artist	staff
2	Mike	TRUE
3	John		TRUE
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12
13
14
15	Distinct People	5
16	Distinct Artists	2	(should be 2)
17	Distinct Staff	3	(should be 3)
Sheet7

Cell Formulas
Range	Formula
B15	B15	=SUM(IF(ISTEXT(A2:A11),1/ COUNTIF(A2:A11,A2:A11),””))
B16	B16	=ROWS(UNIQUE(FILTER(A2:A11,B2:B11=TRUE)))
B17	B17	=ROWS(UNIQUE(FILTER(A2:A11,C2:C11=TRUE)))

 

[JEC]

=TRANSPOSE(BYCOL(B2:C11,LAMBDA(x,ROWS(UNIQUE(FILTER(A2:A11,x))))))

 

[esmarques]

How about

Fluff.xlsm
	A	B	C
1	name	artist	staff
2	Mike	TRUE
3	John		TRUE
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12
13
14
15	Distinct People	5
16	Distinct Artists	2	(should be 2)
17	Distinct Staff	3	(should be 3)
Sheet7

Cell Formulas
Range	Formula
B15	B15	=SUM(IF(ISTEXT(A2:A11),1/ COUNTIF(A2:A11,A2:A11),””))
B16	B16	=ROWS(UNIQUE(FILTER(A2:A11,B2:B11=TRUE)))
B17	B17	=ROWS(UNIQUE(FILTER(A2:A11,C2:C11=TRUE)))

It worked perfectly! Thank you very much.

 

[Fluff]

Glad we could help & thanks for the feedback.