counting the unique values

[Schubby10]

Hey guys,

I have drawn out my unique names and I would like to count them if a certain category says yes or no.

I have my unique values in B2 and my yes or no in F2. How do I could all my yeses and all my nos of the unique values?

 

[Trevor G]

You could use a Pivot table to do this.

 

[Weeble]

Do you mean that your yes and no values are in column F ?
If so, you could count them with

=COUNTIF(F:F,"YES")

anywere on a blank space. And

=COUNTIF(F:F,"NO")

for the other count.

 

[JustynaMK]

Hi,

I'm also not sure if I understood your question correctly - but if you want to count the number of unique values that you have in column B, but only for those rows where column F = "Yes", then you can use the following Array formula (confirm with Ctrl+Shift+Enter):
=SUMPRODUCT(IFERROR(1/IF(F2:F100="Yes",COUNTIFS($F$2:$F$100,"Yes",$B$2:$B$100,B2:B100)),0))