counting text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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
Click to expand...

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

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