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)

In cell D2: Copy down.

2024-06-29_152139.jpg

I made a table of the words you're looking for and what type of case they're related to.
This table needs to be in the order so that when a comment contains 2 or more words you're looking for, the type of case you want to see as a preference comes above the others. You can add/delete rows from this table without needing to adjust the formulae.
See attached.

Attached Files

msofficeforums52614data test.xlsx (18.1 KB, 4 views)

Cross post Countif mulitple criteria in text string [SOLVED]
Please read A message to forum cross posters - Excelguru

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Read the cross post. Will apply for future posts. Thank you!