Forum Discussion
Solved
Counting mix of text and numbers
I'm currently using this formula: =COUNT('All Defects'!A:A) to count cells that contain a numeric value. How do I revise this formula to count a mix of text and numbers?
Then use something like
=COUNTA('All Defects'!A2:A10000)
or if you prefer
=COUNTA('All Defects'!A:A)-1
Thanks! Both of these formulas count the defects but also add the column heading.
Then use something like
=COUNTA('All Defects'!A2:A10000)
or if you prefer
=COUNTA('All Defects'!A:A)-1
- These both worked! Thanks!