Count only fields with text/data, not formulas

COUNTA(A2:A100,"")-COUNTA(A2:A100)

[Edit - didn't notice the space in " " - remove that as Scott suggests then try below]

If range of data is A2:A100 try this formula to count text values but not ""

=COUNTIF(A2:A100,"?*")

or if you want to include numeric values too

=SUMPRODUCT((A2:A100<>"")+0)