Counting occurences of codes in cells

  • Thread starter Thread starter salgud
  • Start date Start date
S

salgud

I have a spreadsheet with various codes separated by periods, in a single
cell. Like:
C
T
C,R
T,C,R
R
and so forth.
It's easy to count the single codes but how do I cound the "C" when it's
with another character? There must be a simple way, without writing code,
to do this. Is there?
Thanks!
 
maybe...

=countif(a1:a10,"*" & "c" & "*")
or
=countif(a1:a10,"*c*")
or if x99 contained the letter c.
=countif(a1:a10,"*" & x99 & "*")
 
If you will only need to count each cell once if it has "C" anywhere in it,
then:

=COUNTIF(A1:A5,"*C*")

HTH,
Paul
 
Back
Top