Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining COUNTIF and LEN
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 -- Guido |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|