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:

[TABLE="class: grid, width: 428"]
<colgroup><col><col><col span="4"></colgroup><tbody>[TR]
[TD][/TD]
[TD]result[/TD]
[TD]S[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]P1[/TD]
[TD]AACCCACAABSA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P2[/TD]
[TD]AAACABCBA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P3[/TD]
[TD]ASCAAABCABCS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P4[/TD]
[TD]BCBSABBA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P5[/TD]
[TD]BBCSAACA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P6[/TD]
[TD]SSBSCBACACBB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P7[/TD]
[TD]SSACCSBSBSSB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P8[/TD]
[TD]AASSCCBCBB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P9[/TD]
[TD]SCBBCSCBCSCB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P10[/TD]
[TD]SSBBASBCCSSC[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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