Count certain characters

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am running WIN XP Home with Office XP Pro.

I have a form that I need only select symbols to be added.
I need to be able to count the number of "/" that are in
a column. This column also includes blank cells and the
letter "C". If anyone knows how this can be done I would
appreciate the help.
 
One way

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

if there are more than one / per cell


=SUMPRODUCT(LEN(A1:A1000)-LEN(SUBSTITUTE(A1:A1000,"/","")))
 
Back
Top