| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I combine CountIf with IF or AND?
Can I make the CountIf function conditional by preceding it with IF as follows:
=IF(O8:O264 0,(CountIF(M8:M264,"Issued",N8:N264)+CountIf(M8:M 264,"Delivered",N8:N264)) This formula doesn't work, but you can see what I'm trying to do. Alternatively to do the same thing using AND: CountIF(AND((M8:M264,"Issued",O8:O264 0),N8:N264)+CountIf(AND((M8:M264,"Delivered",O8:O 264 0),N8:N264)) This also doesn't work. Any tips? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine countif and sumproduct? | Excel Worksheet Functions | |||
| How to combine SUMPRODUCT with COUNTIF? | Excel Worksheet Functions | |||
| Combine COUNTIF & EXACT | Excel Discussion (Misc queries) | |||
| Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
| How do I combine 2 COUNTIF formulas?? | Excel Worksheet Functions | |||
Threaded Mode
