i cannot understand the reply .

Yes i agree the count will be 4 .

I am using the formula as below :

countif(a1:a3,"capability")+countif(a1:a3,"compete ncy")

the above formula gives the result as 4 as it does the count separately for capability and separately for competency .

But i have only three rows .

As the no of rows is only 3, i want it to count 3 and not 4


Is there any way we can merge these formula so that it checks the rows only once and if any 1 condition satisifies , the row will be counted ..Otherwise it will not be counted .