Formula to Count
 

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

Formula to Count
 

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?

Formula to Count
 

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?

Formula to Count
 

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?

Formula to Count
 

Maybe

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

Mike

"TGalin" wrote:

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

Formula to Count
 

It works. I tried it out. Thank you.

"Rick Rothstein" wrote:

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?

Formula to Count
 

I tried it out and it worked. Thank you.

"Mike H" wrote:

Maybe

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

Mike

"TGalin" wrote:

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

Formula to Count
 

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?