How to count just the text.

Diego Casillas Zaragoza

Hello,

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?

Mark Safran

Hi Diego

You should be able to utilize the Contains( ) function for this. Try this out:

=COUNTIF({Chamber Range 1}, CONTAINS("queue", @cell))

-MS