hi
can you please put int in grid format so that i can figure it out what you
want?


"PeterM" wrote:

I have a cell that contains....

"2 red hat, 1 green glove, 2 red glove, 2 yellow hat"

What I need to be able to do is; count the number of items containing "2
red" and return the value 4.

And; count the number of items containing "2 yellow" and return the value 2.

I've tried using COUNTIF, FIND, SEARCH, etc. and can't come up with a way to
do it.

Thank you in advance for your help!