One way:
=SUMPRODUCT(--(LEN(A2:A200)7))
For an explanation of "--" see
http://www.mcgimpsey.com/excel/doubleneg.html
In article ,
"Guido Cole" wrote:
I need to count the number of cells in a range containing moer than 7
characters. =COUNTIF((A2:A200),LEN7)) does not seem to work. Any help would
be appreciated