Excel VBA/Formula Selective Count

[bjoshi]

Hi,

If I have the following data,

A1 SS
A2 10
A3
A4 20

then how do I get the COUNT of the cells that contain only numeric values (i.e. 2 in the above example, A2&A4) in cell A5.

Thanks. Much appreciated.
bjoshi

[nilem]

Is it not appropriate?
=COUNT(A1:A4)