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 .