EXCEL Help please

[Jesson]

Does anyone know what formula i can use to look for specific text within a
range?
IE: i have 20 cells......... 5 have the word "orange" in them, 6 have the
word "red" and 4 have the word"blue".

what i want is to be able to have somewhere where it tells me Total
orange= Total blue= total red=

thanks

 

[Jacob Skaria]

You have items in Column A

=COUNTIF(A:A,"*red*")

If this post helps click Yes

 

[Jesson]

You are a genious jacob, thankyou very much.

now i am going to try and graph the results lol

 

[L. Howard Kittle]

Hi Jesson,

Jacob gave you a solution that will find "red" the range of column A:A. If
you have "red" in a cell it will count it. If you have "Fred" in a cell it
will count that also, along with Red Socks, red Necks and Reddish or
Redford.

If you only want to count the stand alone word "red" in column A:A then...

=COUNTIF(A:A,"red")

Will return a count of RED, red, Red or reD.

HTH
Regards,
Howard