excel - Count only fields with text/data, not formulas - Stack Overflow

Agree with you about removing space, Scott.....but I think your formula will still count ... If range of data is A2:A100 try this formula to count text values but not "".

stackoverflow.com