| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif with mutiple criteria including text
Hello all
Need help Trying to use the sumproduct function to count multiple criteria where one column has text Example: Col. A Col. B 6 Yes, Hot, In 8 No, Cold, Out 6 No, Hot, Out 8 No, Cold, In I'm trying to count col. A if 8 is In Thanks for any sugestions! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif with mutiple criteria including text
try
=sumproduct(--(a2:a22=8),--(right(b2:b22,2)="in) -- Don Guillett Microsoft MVP Excel SalesAid Software "BBOLD" wrote in message ... Hello all Need help Trying to use the sumproduct function to count multiple criteria where one column has text Example: Col. A Col. B 6 Yes, Hot, In 8 No, Cold, Out 6 No, Hot, Out 8 No, Cold, In I'm trying to count col. A if 8 is In Thanks for any sugestions! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif with mutiple criteria including text
.... or preferably with an extra " and an extra closing parenthesis? :-)
-- David Biddulph "Don Guillett" wrote in message ... try =sumproduct(--(a2:a22=8),--(right(b2:b22,2)="in) -- Don Guillett Microsoft MVP Excel SalesAid Software "BBOLD" wrote in message ... Hello all Need help Trying to use the sumproduct function to count multiple criteria where one column has text Example: Col. A Col. B 6 Yes, Hot, In 8 No, Cold, Out 6 No, Hot, Out 8 No, Cold, In I'm trying to count col. A if 8 is In Thanks for any sugestions! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count using multiple criteria including text strings | Excel Worksheet Functions | |||
| CountIF for two columns with two criteria with text | Excel Discussion (Misc queries) | |||
| COUNTIF with text criteria | Excel Worksheet Functions | |||
| Mutiple COUNTIF or equivalent. | Excel Worksheet Functions | |||
| Mutiple match criteria | Excel Discussion (Misc queries) | |||
Linear Mode
