How to count just the text.


I am using =COUNTIF({Chamber Range 1}, "start") to count the number or starts and it works great. but I also need to count the number of "queue" the only problem is queue is usually followed by a number EXAMPLE: queue 10. I don't care about the number, I just want to count the text. does anyone know of a formula that would help?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!