JE McGimpsey wrote...
One way:

=SUMPRODUCT(--(LEN(A2:A200)7))
....

And another,

=COUNTIF(A2:A200,REPT("?",7)&"?*") or =COUNTIF(A2:A200,"????????*")

though this would only count cells containing text. FWIW, cells
containing numbers with nonterminating decimal fractions always have
length exceeding 7.