So, you want a non-VBA solution? In that case:

I don't if you can use =COUNTIF(), but the following should work:

=SUMPRODUCT((ISNUM(X:X)*1)