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
--
Guido
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
--
Guido
One way:
=SUMPRODUCT(--(LEN(A2:A200)>7))
For an explanation of "--" see
http://www.mcgimpsey.com/excel/doubleneg.html
In article <[email protected]>,
"Guido Cole" <[email protected]> wrote:
> 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 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks