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

You have items in Column A

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

If this post helps click Yes
---------------
Jacob Skaria


"Jesson" wrote:

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

You are a genious jacob, thankyou very much.

now i am going to try and graph the results lol

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

"Jesson" wrote in message
...
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