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.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.