I am using the countif statement in the attached file. I am able to pull the word fraud from the text in column C. I need to add multiple criteria to the formula. I tried adding right after the fraud, "*dispute*" but it keeps telling me there are too many arguments.

I have listed which text I want to select under the which topic. etc, Fraud, Service.

Attached Files

data test.xlsx (11.1 KB, 6 views)