Count Multiple Instances of Text in a Cell
 

Oops, misread your post......they don't count multiple instances within a
single cell.

My Bad, sorry

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

Your formulas work fine in my Excel97

Vaya con Dios,
Chuck, CABGx3



"dave roth" wrote:

Good Afternoon:

I need to be able to count multiple instances of the same piece of text in a
given cell, i.e. "blue, blue, red, green." How I currently have this setup
is:

=countif(I2:I44,"*blue*")
=countif(I2:I44,"*green*")
=countif(I2:I44,"*red*")
on separate rows. In the above example these will return 1 blue, 1 green,
and 1 red; I need it to return 2 blues.

Thanks very much, and a good weekend to all.

Dave Roth