Using SEARCH in a single cell to COUNT multiple entries of same te
 

To count how many times a single letter is in an entire cell, use this:

=LEN(Y2)-LEN(SUBSTITUTE(Y2,"C",""))

To do the "double" count for C and S, just double the formula:

=LEN(Y2)-LEN(SUBSTITUTE(Y2,"C",""))+LEN(Y2)-LEN(SUBSTITUTE(Y2,"S",""))

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"tcbooks" wrote:

=(Count(Search("(C)",$Y2)))+(Count(Search("(S)",$Y 2)))

Col Y (row 2) C Type 00 Type S Type
sab12334(C) 0056223(00) 1 1 0
sab22233(C)

The above formula is what I'm using to extract certain equipment types from
a single cell. The problem is that it's only counting 1 time. For example,
cell Y2 above has 3 equipment numbers, 2 of which has the (C) at the end, but
I can't get a formula to count the C Type more than once (there can be upto 3
of same type in a cell).

Help!