Formula to find text

[BridgetteMJ]

Hi,
I am trying to create a formula that will count the number of cells that begin with a certain phrase or have a certain phrase within the text. For example
count the number of cells that begin with "Contract exam requested, awaiting results from".

 

[Tom Urtis]

Maybe a formula like this if your list is in column A for example.

=COUNTIF(A:A,"Contract exam requested, awaiting results from*")


Note the wildcard asterisk after the word or phrase to note begin with. If you wanted to see if it exists anywhere, use enclosing asterisks, example:

=COUNTIF(A:A,"*Contract exam requested, awaiting results from*")

 

[T. Valko]

Hi,
I am trying to create a formula that will count the number of cells that begin with a certain phrase or have a certain phrase within the text. For example
count the number of cells that begin with "Contract exam requested, awaiting results from".

Try this...

=COUNTIF(A2:A10,"*Contract exam requested, awaiting results from*")

 

[BridgetteMJ]

Thank you so much! It worked great. I wasn't using the *.
Bridgette