Count if dependant on text length

[nathan663]

I am looking for a formula (countif - i guess) that will look up cells but will only count them if the text length is more than 3.

Any words equal to or less than three characters will not be included in the count

Nathan

 

[Domenic]

Assuming that A2:A10 contains the data, try...

=SUMPRODUCT(--(LEN(A2:A10)>3))

Hope this helps!

xl-central.com

 

[Prabby1981]

Try this formula if the text is in column A:

=SUM(IF(LEN($A:$A)>3,1,0))

Close the formula with CTRL + SHIFT + Enter and not usual Enter.


Hope this helps !