If all you are doing is counting, then you can use these formulas

=SUMPRODUCT(IF(ISERROR(FIND("RPJU",A1:A2)),0,1))
and
=SUMPRODUCT(IF(ISERROR(FIND("10D",A1:A2)),0,1))

replace A1:A2 with the actual range. It is an array function, so you will
need to enter them with ctrl+shift+enter.

"djDaemon" wrote:

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.