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
Use COUNTA instead of COUNT.
COUNTA(range) returns the number of non-blank cells in range.
Remark: a cell that contains a formula that returns "" counts as non-blank even though it looks blank.