I have a list similar to the one given below and i have to count a value (for example "DCDF") in this list, the "COUNTIF" calculates the entry (DCDF) in the cell where it exists alone but not in the cell where there is another entry present alongwith "DCDF"
DCDF
DCDF,MNAC,MXAC
NVAR,NVAO,DCDF...