Counting cells with data in them while containing a formula

Hello,

I am trying to run a formula to determine how many cells in a range have data in them. The cells will all have a formula in them. The data could be numbers, letters, have hyphens or periods, etc.

I tried using using Count but it does not work with hyphens and I tried using COUNTA but it considers cells with formulas in them as containing data even if it is blank.

I have attached a spreadsheet as an example. The correct formula should show a count of 9 from the range of B2:B21.

Thanks!

Change the formula in B2 to:

=IF(K2>0,K2,"")

Try this:

=COUNT(B2:B21)+COUNTIF(B2:B21,"?*")

Or:

=SUMPRODUCT(--(LEN(B2:B21)>0))

That worked great! Thank you.