Try this:

=SUMPRODUCT(--(A1:A10="Joe"),--(B1:B10="Yes"))

Biff

"Richard" wrote in message
...
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