Combining COUNTIF and LEN

[Guest]

I need to count the number of cells in a range containing moer than 7
characters. =COUNTIF((A2:A200),LEN>7)) does not seem to work. Any help would
be appreciated

 

[JE McGimpsey]

One way:

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

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

 

[Harlan Grove]

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.