Count Cells with Text longer than

  • Thread starter Thread starter paulmoles
  • Start date Start date
P

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
 
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,
 
(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.
Click to expand...

One way,

=COUNTIF(D34:F44,"????*"
 
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.
Click to expand...

One way,

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