I have 50+ employees whose names I add to my "tracking" worksheet and I want
to quantify all of my data on my "analysis" sheet, so I'm getting data from
another sheet - don't know if this matters. I tried this:
=SUMPRODUCT(--('2007_Corrective'!C:C="LAST,
FIRST"),--('2007_Corrective'!F:F="yes"))
.... and I get #NUM! error.

"JE McGimpsey" wrote:

One way:

=SUMPRODUCT(--(A1:A100="Joe"),--(B1:B100="yes"))

In article ,
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