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: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095
Thank you in advance for your assistance.
Help Article Resources
Check out the Formula Handbook template!