Counting the Number of times certain text appears in a Column


I need assistance to create Sheet Summary items to count all of the instances where certain Unit Code(s) is listed in a column. Some codes can be combined with others (C1 + C2) vs by themselves (C2).

So, to start I need to count the number of times Unit Code "C2" is listed/mentioned. Eventually I will also need to capture the times other instances/combinations are listed as well. I have a few Sheet Summary items created to represent these options.

I have searched and tried different formulas, but nothing seems to get to the result I'm looking for.

Test sheet is here to show example:

Thank you in advance for your assistance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!