EXCEL Help please

  • Thread starter Thread starter Jesson
  • Start date Start date
J

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
 
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
 
Back
Top