Count Unique Criteria Based on Criteria in One Column

[Elissa1004]

I searched the other forums on counting unique criteria, but I was unable to locate an answer that fit what I am trying to do.

Here is my data:

Column A B C
Smith, Susie Operations Yes
Brown, Charlie Accounting Yes
Grass, Green Admin No
Smith, Susie Acounting Yes
Smith, Susie Operations No
Brown, Charlie Accounting Yes
Brown, Charlie Accounting No
Smith, Susie Operations Yes

I am trying to count when column C says "yes" and column A and B match, but only once. For example, in the scenario above Smith, Susie would be counted 2 times even though she is listed 4 times. She would be counted once for "yes" and "operations" and once for "yes" and "accounting". Charlie Brown would be counted 1 time and Grass, Green would not be counted at all because column C does not say yes.

I appreciate any help available! Thanks

 

[T. Valko]

I searched the other forums on counting unique criteria, but I was unable to locate an answer that fit what I am trying to do.

Here is my data:

Column A B C
Smith, Susie Operations Yes
Brown, Charlie Accounting Yes
Grass, Green Admin No
Smith, Susie Acounting Yes
Smith, Susie Operations No
Brown, Charlie Accounting Yes
Brown, Charlie Accounting No
Smith, Susie Operations Yes

I am trying to count when column C says "yes" and column A and B match, but only once. For example, in the scenario above Smith, Susie would be counted 2 times even though she is listed 4 times. She would be counted once for "yes" and "operations" and once for "yes" and "accounting". Charlie Brown would be counted 1 time and Grass, Green would not be counted at all because column C does not say yes.

I appreciate any help available! Thanks

Try this...

Book1
	A	B	C
2	Brown, Charlie	Accounting	Yes
3	Brown, Charlie	Accounting	Yes
4	Brown, Charlie	Accounting	No
5	Grass, Green	Admin	No
6	Smith, Susie	Operations	Yes
7	Smith, Susie	Acounting	Yes
8	Smith, Susie	Operations	No
9	Smith, Susie	Operations	Yes
10	_	_	_
11	Smith, Susie	2	_
Sheet1

This array formula** entered in B11:

=SUM(IF(FREQUENCY(IF(C2:C9="yes",IF(A2:A9=A11,MATCH(A2:A9&B2:B9,A2:A9&B2:B9,0))),ROW(C2:C9)-ROW(C2)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[Elissa1004]

Thank you so much! That worked perfectly!

 

[T. Valko]

Thank you so much! That worked perfectly!

You're welcome. Thanks for the feedback!