Try this:

=SUMPRODUCT(--(A2:A7="x"),--(ISNUMBER(MATCH(B2:B7,C2:C3,0))))

--
Biff
Microsoft Excel MVP


"Sergio Dutra" wrote in message
...
Hi, I have the following table:

Area Person Members
X Jack Jack
Y Mary Peter
Z Jack
X Peter
X Mary
Z Mary

I want to count the number of Persons who are Members and have entries in
Area X. So in the example above it should return 2 (Jack and Peter have X
entries and are Members but Mary is not a member though she has X entry).

How to do this in Excel?