Countif with two criterias

[Guest]

Hi all

I need your help. i need to use the countif but with two criterias ...
something like the sumproduct and the sum if.

Example:
Col. A Col. B
Joe Yes
John No
John No
Joe Yes
Joe No

I need to count how many Joe with Yes I have.

Thanks,

 

[John Bundy]

Easiest is to concantenate put this in C2
=A1&B1
then put your criteria in a column as one word
joeyes
then do your countif
=COUNTIF(C2:C6,D1)

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20="Joe"),--(B2:B20="Yes"))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Bob Phillips]

If you have Excel 2007, you can use

=COUNTIFS(A2:A20,"Joe",B2:B20,"Yes")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

Thanks Bob

"Bob Phillips" escreveu:

If you have Excel 2007, you can use

=COUNTIFS(A2:A20,"Joe",B2:B20,"Yes")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

Thanks Dave

With your help finally I finished my work

"Dave F" escreveu: