You can't use entire columns as range references unless you're using Excel
2007.

Use a smaller range. Also, the ranges must be of equal size.

Biff

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