Assuming that A2 contains the text string, let C2:C5 contain A, B, C,
and D, then enter the following formula in D2 and copy down:

=SUMPRODUCT(--(MID($A$2,ROW(INDEX($A:$A,1):INDEX($A:$A,LEN($A$2) )),1)=C2)
)

Hope this helps!

In article ,
Pookie76
wrote:

Is it possible for me to have excel sum all the one letter codes into
individual cells and let me know the count?

Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
and have those sums placed in an individual cell for each?

Thanks for the help.