PDA

View Full Version : Solved: Count Cell if it is numeric



Aussiebear
05-16-2010, 03:36 AM
I would like to count a cell in the range A2:A13 if its value is numeric, so would I use something like this

=COUNTIF(ISNUMBER(A2:A13))

mdmackillop
05-16-2010, 03:48 AM
=COUNTIF(A:A,">-1")

Bob Phillips
05-16-2010, 04:12 AM
=COUNT(A2:A13)

Aussiebear
05-16-2010, 04:44 AM
Thank you MD & Bob. Here I was thinking it was something far more complex.