Vlookup to count if value is "X"

[henry carvalho]

Hi

I am trying to search how to get Vlookup action worked with Countif

Names E G F P
abc X
cde X
fgh X
ijk X

Is there any way that I can count only the values relating to "CDE" in
column "G"?

 

[Jim Cone]

=SUMPRODUCT((B6:B9="cde")*(G6:G9="X"))
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

..
..
..

"henry carvalho" <[email protected]>
wrote in message
Hi
I am trying to search how to get Vlookup action worked with Countif

Names E G F P
abc X
cde X
fgh X
ijk X

Is there any way that I can count only the values relating to "CDE" in
column "G"?