hi all,

i need excel formula to count data with ignore mark "-" and "" (empty/blank cell), only counting text;
like this below ;

-----value---------
john
mike
-
sisca
-
blank cell
blank cell
-
jordan782
----------------
4 (expected result)

how dot it?

thank in advance...

john m