This works also. Lean is always better.

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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
--
Rick (MVP - Excel)


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