Counting Unique Values from one Column and determining the count of another column based on that

[Gagnrath]

Hello,

I was recently trying to determine a way to count the unique values of one column and use that to determine the count of Yes Answers from another column based on that.

Ex.

Column A|Column B
00000 |Yes
00001 |Yes
00000 |No

So, I wanted to take the unique Values of Column A and determine narrow down the Yes Answers from Column B to determine the sum of them.
So in the example, there would only be 2 as the sum of these. There may also be some blank value in the First Column as well.

I tried incorporating this into my formula as it provides all the quantity of Unique values of all of Column A
=SUM(IF(FREQUENCY(MATCH(B2:B1000,B2:B1000,0),MATCH(B2:B1000,B2:B1000,0))>0,1))

Any help on this is welcome as I have tried several attempts and all have failed.

 

[AhoyNC]

See if this works for you.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D
1
2	00000	Yes
3	00001	Yes		2
4	00000	No
5
6	00000	Yes
7
Sheet

 

[Gagnrath]

That worked great. Thanks for the help

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.