Countif with two criterias
 

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,

Countif with two criterias
 

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)
--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

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

Countif with two criterias
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


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

Countif with two criterias
 

You can use SUMPRODUCT: =SUMPRODUCT(--(A1:A10="Joe"),--(B1:B10="Yes"))

You can't use SUMIF with multiple criteria. You could use COUNTIF if you
were to concatenate columns A and B and do the COUNTIF off that column of
concatenated text strings, as suggested by the other person to respond.

Dave
--
Brevity is the soul of wit.


"Ricardo" wrote:

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,

Countif with two criterias
 

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)


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

Countif with two criterias
 

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)


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

Countif with two criterias
 

Thanks Dave

With your help finally I finished my work

"Dave F" escreveu:

You can use SUMPRODUCT: =SUMPRODUCT(--(A1:A10="Joe"),--(B1:B10="Yes"))

You can't use SUMIF with multiple criteria. You could use COUNTIF if you
were to concatenate columns A and B and do the COUNTIF off that column of
concatenated text strings, as suggested by the other person to respond.

Dave
--
Brevity is the soul of wit.


"Ricardo" wrote:

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,