PDA

View Full Version : Excel VBA/Formula Selective Count



bjoshi
12-11-2011, 01:10 PM
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
12-11-2011, 01:45 PM
Is it not appropriate?
=COUNT(A1:A4)