| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a countif statement with multiple conditions
countif cell a=ace and cell b=club, diamond, or spade. this is in a very
large spreadsheet |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a countif statement with multiple conditions
try =sumproduct((a2:a22="ace")*(b2:b22={"club","diamon d","spade"})) -- Don Guillett Microsoft MVP Excel SalesAid Software "perfect_one1" wrote in message ... countif cell a=ace and cell b=club, diamond, or spade. this is in a very large spreadsheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with If-then statement with multiple conditions | Excel Worksheet Functions | |||
| IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
| Multiple conditions on a countif | Excel Worksheet Functions | |||
| If statement using multiple conditions | Excel Worksheet Functions | |||
| COUNTIF Statement with Multiple Conditions in Different Ranges | Excel Worksheet Functions | |||
Linear Mode
