Counting Occurence of String of Text in a Cell
I need suggestions on how to count strings of text on a cell.
My cell contains: Triple MXL, SMax Pivot Door, SMax Pivot Door
I need to count: SMax Pivot Door and get the result: 2
The function I'm trying is giving me the wrong result:
=COUNTIF([Product - all]@row, CONTAINS("SMax Pivot Door", @cell))
I also tried to use the dropdown menu and count that, but I can't have duplicates there.
Thank you so much :)
Help Article Resources
Check out the Formula Handbook template!