Count given characters in cell value

[CsJHUN]

Hi guys,

i would like to get a help from you. I need a formula, macro whatever for this table:

	result	S	A	B	C
P1	AACCCACAABSA
P2	AAACABCBA
P3	ASCAAABCABCS
P4	BCBSABBA
P5	BBCSAACA
P6	SSBSCBACACBB
P7	SSACCSBSBSSB
P8	AASSCCBCBB
P9	SCBBCSCBCSCB
P10	SSBBASBCCSSC

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

I would like to count how many S and A and B and C in the cell on column B(result)
Any ideas welcome

 

[etaf]

in C2 put
=LEN($B2)-LEN(SUBSTITUTE($B2,C$1,""))
and copy across and down

Substitute is case sensitive
=LEN($B2)-LEN(SUBSTITUTE(UPPER($B2),C$1,""))
so you can convert all to upper case

 

[CsJHUN]

TY, works as charm
really nice thinking, absolutely love it

 

[etaf]

your welcome