Count Text

[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

 

[Peo Sjoblom]

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"))

 

[Gord Dibben]

Jim

=COUNTIF(A:A,"*abc*")

=COUNTIF(1:1,"*abc*")

Gord Dibben Excel MVP