Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("rpju",A1:A100))))

Better to use a cell to hold the criteria:

B1 = rpju

=SUMPRODUCT(--(ISNUMBER(SEARCH(B1,A1:A100))))

Biff

"djDaemon" wrote in message
...
Sheet contains several cells with assembly numbers that vary according to
type. For instance, here are just two (of many) examples.

RPJU10010D153J5M-N
RCU09314W303JC-N

Notice that the strings vary in overall length, as do the "internal" parts
of the string. For instance, the "RPJU" and "RCU" both indicate a
characteristic of the assembly.

I would like to be able to count how many occurences of "RPJU" there are,
as
well as how many contain "10D", etc. Each of these sections of the part
number indicate a different characteristic, so I'm trying to coallate this
into another sheet.

So, how can I sum the instances of these types?

Thanks in advance.