| Home |
| Search |
| Today's Posts |
|
#5
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, |
| 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 | |||
Threaded Mode
