counting text

[stavrou]

hi
I would like to count the number of times a specific letter is found in a range of cells.
With countif function i get only a count of cells containig the specifig letter

Thanks

 

[Andy B]

Hi

Try using the FIND() function.

Andy.

 

[Dave R.]

Count the total number of characters in the range of cells, then subtract
the # of characters after using a substitute formula where u substitute your
letter of interest with "" and the result will be the # of your character in
those cells.

 

[STAVROU]

I am using 5 different letters as codes (a-f). There is a daily data input in different cells. Different letter can be used in each cell. e.g cell h8 can contain aab, cell i8 can contain aabd etc.
I would like to add all similar letters in cells b8 to f8. say in b8 number of occurrences of letter a, in c8 number of occurrences of letter b etc

Thanks

 

[Harlan Grove]

Try using the FIND() function.

?

How would this help? Provide details!

 

[Harlan Grove]

I would like to count the number of times a specific letter is found in a
range of cells.
With countif function i get only a count of cells containig the specifig letter

To count all instances of the character # in A1:H10, try

=SUMPRODUCT(LEN(A1:H10)-LEN(SUBSTITUTE(A1:H10,"#","")))