Search a column for a phrase and return a number

[Jazzzola324]

Hello,
I am trying to figure out a formula which will search a column for a phrase and if that phrase is present then display a number.
any help would be appreciated

 

[My Aswer Is This]

This formula will search Column(A) for the phrase "Alpha" and give you how many times it found "Alpha" in Column(A)

=COUNTIFS(A:A,"Alpha")

 

[Jazzzola324]

Hi,
Thanks for responding. That’s not exactly what I mean. I need to search a column for a word or phrase, if that word or phrase is present then display a number.
For example, I need it to search a column for ‘Somewhat’, if that word is in the column then I need it to display the number 2.

 

[My Aswer Is This]

Give me a exact example. I had my formula search Column (A) for Alpha

Your saying you want to search some column for "

Somewhat"

and if found display 2

so if found display 2

In your example how many times did the formula find

Somewhat

Please give me the exact Column

Say Column A or column B do not say some column

My example used column A can you not change A to P or G or what.


​

<sub><sup><strike>



</strike></sup></sub>​

 

[Jazzzola324]

Hi,
somewhat will not appear multiple time just once or not at all.if it does appear I’d like the formula to display the number 2. A formula using column A would be fine.
Thanks

 

[My Aswer Is This]

Try this:
=IF(A:A="somewhat","2","")

 

[Jazzzola324]

That didn’t seem to work. Weirdly, once I entered the formula it browsed documents on my computer and in the cell it displayed “ref#”

 

[My Aswer Is This]

I'm sorry try this:

Change "Cake" to what you want.

=IF(COUNTIF(A:A,"Cake"),"2","")