Count frequency with multiple conditions

[Supermike1983]

I would like to count how many unique values (= the frequency) in column A with the following conditions:

* I only want to include values corresponding to an "X" in Column B
* I only want to count the number of values in Column A which are constantly "Blank" in Column C. Meaning if I have a specific value in Column A with an "X" in Column B occuring multiple times I would like to exclude all these cases if they are not "Blank" in all cases.


In the example below 19, 17, 16 corresponds to these conditions meaning the frequency answer should be =3. But I seem to have a hard time getting rid of the cases where I both have blanks and letters for the unique number in Column A.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B [/TD]
[TD] Column C [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]X[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl69, width: 106"]26[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="width: 106"]14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]X[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Y[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Y[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Supermike1983]

I know it's a very stupid example but I've switched all the data into something completely else for business-related reasons. Still it's the unique blanks I want to single out and count.