Count number of occurences of letter in cell and row

[t11uyn]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Amy[/TD]
[TD]Bob[/TD]
[TD]John[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]A,A,A[/TD]
[TD][/TD]
[TD]A,[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]B,B[/TD]
[TD]B,B,B[/TD]
[TD]B,B[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Lettuce[/TD]
[TD]L[/TD]
[TD]L,L,L[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


Hello,


I am looking to count the number of occurrences a letter appears in a row. This letter can also appear multiple times in a cell.

If I use the formula below it will count the single cell, but I am looking to total up the entire row so it gives the total like in my example
=LEN(B2)-LEN(SUBSTITUTE(B2,"s",""))

Also it is possible that one cell may have more than one type of letter. For example B3, could have B,B,B,T,T. But I would only want to count all the Bs.

Is there an easier way of doing this? Many thanks

 

[t11uyn]

I managed to figure this out. For anyone's reference I used the formula:

=SUMPRODUCT(LEN(range)-LEN(SUBSTITUTE(range,"B","")))