Forum Discussion

Copper Contributor

Dec 14, 2022

Counting text strings with variations

I would like to count the occurrence of the text string "ama" within a column, e.g. =COUNTIF(A1:A6000),"*ama*") However, I would also like to count other variations: amas, ama's, AMA, AMAs, AMA...

excel

Formulas and Functions

JXHK_22

Copper Contributor

Dec 14, 2022

Hi there. Thanks for your help, but not sure that I understand. I mean that I would like to count all variations as a standalone string (ama, amas, ama's, AMA, AMAs, AMA's) but not any instances where the string appears within another word such as Amanda.

peiyezhu

Bronze Contributor

Dec 15, 2022

please，
Attach a sample excel file to your post. Show input and desired output.