Count Cells with Text longer than

[paulmoles]

I want to count the number of cells in an area eg
(d34:f44), that have text entries longer than 3
carachters. But cannot find the syntax.

Excluding cells therefore that are either blank or only
contain short words (abbreviations).

Help appreciated.

Paul Moles

 

[Alan]

One very inelegant way,
In a vacant area enter, say G34:I44
=Len(D34) and copy through your range then
=COUNTIF(G34:I44,">"&3)
Regards,

 

[hgrove]

(e-mail address removed) wrote...

I want to count the number of cells in an area eg (d34:f44), that
have text entries longer than 3 carachters. But cannot find the
syntax.

One way,

=COUNTIF(D34:F44,"????*"

 

[JE McGimpsey]

one way:

=SUMPRODUCT(--(LEN(A1:A1000)>3))

For an explanation of the --, see

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


"(e-mail address removed)"

 

[RagDyer]

Nice!
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

(e-mail address removed) wrote...

I want to count the number of cells in an area eg (d34:f44), that
have text entries longer than 3 carachters. But cannot find the
syntax.

One way,

=COUNTIF(D34:F44,"????*")