COUNT number of unique values in column A, based on criteria matching columns B and C

Hi Everyone

I have 3 columns as follows

A B C
1 x yes
2 stock no
2 future yes
2 future yes
3 x no
4 x yes
4 stock yes
5 future yes
5 x yes
5 future no
5 future yes

I want a formula to count the number of unique values in column A where column B is "future" and column C is "Yes"

So the answer in this example would be 2, because only numbers 2 and 5 have any instances of "future" AND "yes" in columns B and C.

Any help would be hugely appreciated.... it needs to be automated to feed graphs, so unfortunately a pivot table won't suffice.

Many thanks in advance

Thanks this worked a treat.

=SUM((FREQUENCY(IF((B2:B12="Future")*(C2:C12="Yes"),A2:A12),A2:A12)>0)+0)