Hi All,

I am after a formula which only counts 1 "Yes" response from each person. Here is an example below:

example.png

Basically, I would like a forumla that counts how many times "Yes" has appeared in column B, HOWEVER it will only count 1 "Yes" vote from each person.

For example, in this picture person A has answered "Yes" twice, but I want this to only be counted as 1. Any future times person A has answered "Yes" will not be counted. The same for person B, C and D and so forth. I am after the total of this frequency, which in this example would be 4.

Is this possible?

Thank you!