On the example, 'A1' & 'A6' should be 'A' & 'E' - thx

"Richard" wrote:

I want to count # of times a value(name) appears in a column IF, in another
column on the same row, "yes" exists. Example:
A1 A6
Joe yes
Joe no
Joe yes

Count here should equal 2.
Thanks