count - special criteria

masterphilch · Oct 27, 2004

Hi

Is it possible to count cells in a range than contains f.e. "/" or that
begins with "/"?

thx

Frank Kabel · Oct 27, 2004

Hi
try
=COUNTIF(A1:A100,"*/*")
or
=COUNTIF(A1:A100,"/*")