Counting based on the occurrence of text in a cell

Hello,

I need to add text based on the occurrence of text in string but I
cannot discount the remainder of a string.

I am looking for the occurrence aaaa.bbb.ccc in the following text and
I need them counted but also based on criteria in another field, as
follows:

Column A Column B

aa.bb Yes
aa.bb.cc No
aa.bb.cc.dd Yes
aa.bb.cc.dd.ee Yes
aa.bb.cc.dd.ee.ff Yes
aa.bb.cc.dd.ee.ff.gg No
bc.dd.cc.ee.ff.gg.hhh
bc.ba.cc.ee.ff


I need to count all of the occurrences of aa.bb but also include those
which have text beyond aa.bb in the account. The aa.bb denotes an area
of the company and get's more specific the longer the line of text is.
I am trying to add up the numbers of aa.bb where column b=yes but
Excell does not seem to include the cells which have text beyond the
aa.bb (i.e aa.bb.cc.dd.ee, etc.)

Any help would be greatly appreciated.

Thanks,

Scot


---
Message posted from http://www.ExcelForum.com/