Formula to Count

[TGalin]

Is there a formula that will count how many times a word that is 4 characters
long appears in column M?

 

[TGalin]

It works. I tried it out. Thank you.

Here is another way to do what you want using this array-entered formula...

=COUNT(IF(LEN(A1:A100)=4,1))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself

 

[TGalin]

I tried it out and it worked. Thank you.

Maybe

=SUMPRODUCT(((LEN(A1:A22)=4)+0)*(ISTEXT(A1:A22)))

Mike

 

[TGalin]

This works also. Lean is always better.

We can save two characters by using this array-entered formula instead of
the one I posted originally...

=SUM(IF(LEN(A1:A100)=4,1))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself

 

[Bernd P]

Hello Rick,

Far too long

Array-enter:
=SUM(--(LEN(A1:A100)=4))

SCNR,
Bernd