How to count these names?

[ravi8]

Thank you for your help in advanced. I need to help to understand what the formula should be for the total for each column. It needs count Yes once per name. In this name, subject 1 should calculate 4, Subject 2 should calculate 3 and Subject 3 should calculate 2.

If I changed row 5 from Name1 to Name 5, the calculation for Subject 1 should increase to 5.

I hope you can guide me on this please. Thank you so much.

	Subject1	Subject2	Subject3
Name1	Yes	Yes
Name1		Yes	Yes
Name1			Yes
Name1	Yes	Yes	Yes
Name2
Name2	Yes
Name2	Yes
Name2
Name3	Yes	Yes
Name3	Yes	Yes
Name3		Yes
Name3	Yes
Name4	Yes	Yes	Yes
Name4
Name4	Yes	Yes
Name4
Total subjects per name	[Formula?]	[Formula?]	[Formula?]

 

[sadath]

=COUNTA(UNIQUE(FILTER($A$2:$A$17,B2:B17="Yes")))

 

[ravi8]

=COUNTA(UNIQUE(FILTER($A$2:$A$17,B2:B17="Yes")))

Beautiful, thank you so much, that's perfect!

 

[Alex Blakenburg]

Unfortunately that will give you a count of 1 if Yes does not appear anywhere in the column.
Its a bit convoluted to avoid that from happening.

=SUM(--(UNIQUE(FILTER($A$2:$A$17,B$2:B$17="Yes",0))<>0))

 

[RoryA]

Just be aware that that will return 1 even if there are no Yes values at all for a Subject. You can avoid that with something like:

=IFERROR(ROWS(UNIQUE(FILTER($A$2:$A$17,B2:B17="Yes"))),0)