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))
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))
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
=COUNTIF(A:A,">-1")
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
=COUNT(A2:A13)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you MD & Bob. Here I was thinking it was something far more complex.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link