Count certain characters

[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.

 

[Peo Sjoblom]

One way

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

if there are more than one / per cell


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

 

[Dave Peterson]

=countif(a:a,"/")

Might do it for you if there's only the slash in the cell.

 

[Gord Dibben]

Jason

=COUNTIF(A1:A50,"=/")

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

Gord Dibben XL2002

 

[Jason]

Thanks for the help. It worked great.

Also thanks for the quick reply.