Moved to Excel forum. You posted in a "No Questions" Forum
Is there a way to use Countif to count non blank spaces.
I have tried many variations in the criteria, including:
=countif(e14:e20,"<>"""), =countif(e14:e20,"<>isblank()"), etc.
None seem to work.
Am I missing something?
1. Why answer a question that is 10 years old?
2. Why use VBA when a formula exists, and in fact has already been suggested?
You would be better reading the Forum Rules than spending time on an old question. That way you would know about using Code Tags!
There are currently 1 users browsing this thread. (0 members and 1 guests)