TGalin,

If you only have single words in the cells:

=SUMPRODUCT((LEN(M1:M1000)=4)*1)

HTH,
Bernie
MS Excel MVP


"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?