I am trying to count how many cells in a single column range contain data (text), but none of the following work:
=countif(b7:b17,"<>""")
=countif(b7:b17,">0")
Or count the ones that are empty:
=countif(b7:b17,"=""")
=countif(b7:b17,c1) [where C1 is empty]
What gets me is that I am 99% sure I have done this before!
Thanks!
Alex
Bookmarks