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