Need to count unique values based on another column

[PatrickArnold16]

Hi,
I am trying to get a formula where i am trying to count the number or unique values in Column A based upon a Yes value in Column K.

I can get the unique in column a but cant seem to combine them into 1 formula

Anyone have any suggestions.
Thanks

 

[Automatrix]

Book1
	A	B	C	D
1	A	B
2	A	Yes		2
3	A	Yes
4	A	No
5	B	No
6	B	Yes
7	B	No
8	B	Yes
9	C	No
10	C	No
11	C	No
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTA(UNIQUE(FILTER(Table1[A],Table1[B]="Yes")))

 

[Fluff]

Another option that will handle no Yes values in col K

=IFERROR(ROWS(UNIQUE(FILTER(A2:A1000,K2:K1000="yes"))),0)