Trying to create formula to exclude any cells that contain the word "D/C"

Hello everyone!

I currently have a template that contains employee names and what I am looking to do is exclude any cell that would contain the word D/C infront of an employee's name, ex: D/C John Smith...I've tried many different functions and I haven't been able to figure it out, I've even tried to remove the slash, just in case it was affecting the formula, but still nothing. I've even tried to do the COUNTIF function, but I haven't yet been able to figure anything out.

I am currently using the COUNTIF function and the COUNTBLANK function in order to exclude all of the cells that contain the words NOT REQUESTED and exclude the cells that are blank, and this is currently working great! My formula looks like this:

=COUNTIF('MONDAY-TUESDAY'!C:C,"<>*NOT REQUESTED*")-COUNTBLANK('MONDAY-TUESDAY'!C:C)

I've tried replacing the NOT REQUESTED with the word D/C, but it's not working...

Any input would be greatly appreciated.

Thank you in advance

Re: Trying to create formula to exclude any cells that contain the word &quot;D/C&quot;

Hi Skywriter, thank you for your quick response, however, I've already tried that and it doesn't work. It gives me a random number

Re: Trying to create formula to exclude any cells that contain the word &quot;D/C&quot;

Thank you each and every one of you for your ideas!! The formula that has ended up working is the following:

=COUNTIF('MONDAY-TUESDAY'!C:C,"<>*NOT REQUESTED*")-COUNTIF('MONDAY-TUESDAY'!C:C,"D/C*")-COUNTBLANK('MONDAY-TUESDAY'!C:C)

I had to remove these <> for the formula to work properly!

Thanks again everyone!