| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count if with Multiple criteria
I have a column which can contain text as below :
Competency Capability Capability & Competency I want to count all the cells which contains either competency / capability or both . The count of the above should be 3 and not 4 . If we do 2 separate count if and add it will give 4 but what i need it to count is only 3 . ( i.e no of unique rows which has any one of this input ) . Can anyone help me how to do this . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count with multiple criteria in multiple cells | Excel Worksheet Functions | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Threaded Mode
