Count Text

  • Thread starter Thread starter Jim Higgins
  • Start date Start date
J

Jim Higgins

Does Excel XP have a function to count instances of specific letter
combinations (acronyms) in a given row or column?

--
Remove first letter left of dot to reply

"A democracy is a sheep and two wolves deciding on what to have for
lunch. Freedom is a well armed sheep contesting the results of the
decision."
Benjamin Franklin
 
Yes,

try

=COUNTIF(B2:B20,"*jim*")

if there might be multiple strings in the same cell

=SUMPRODUCT((LEN(B2:B20)-LEN(SUBSTITUTE(B2:B20,"jim","")))/LEN("jim"))
 
Back
Top