help in counting a single character

[Jim]

Is there a formula to count every occurence of a
character. The following formula counts the number of
cells with the letter 's'. =COUNTIF(A1:F35,"*s*"). I need
to have a count of all occurences of the letter 's'. So
if there is 2 's' in one cell, the count will show this.
Thanks for any help.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(LEN(A1:F35)-LEN(SUBSTITUTE(A1:F355,"s","")))

 

[JIM]

Thanks, that worked great.

-----Original Message-----
Hi
try
=SUMPRODUCT(LEN(A1:F35)-LEN(SUBSTITUTE(A1:F355,"s","")))

--
Regards
Frank Kabel
Frankfurt, Germany


.