| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Count
Is there a formula that will count how many times a word that is 4 characters
long appears in column M? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
| Count formula | Excel Discussion (Misc queries) | |||
| Trying to construct a count count formula | Excel Discussion (Misc queries) | |||
| Need a Count Formula | Excel Worksheet Functions | |||
| Count down formula | Excel Worksheet Functions | |||
Linear Mode
