Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF with two criteria's | Excel Worksheet Functions | |||
2 criterias for countif - | Excel Worksheet Functions | |||
Countif, two criterias need help | Excel Worksheet Functions | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
countif help for multiple criterias | Excel Worksheet Functions |