T TGalin Apr 3, 2009 #1 Is there a formula that will count how many times a word that is 4 characters long appears in column M?
Is there a formula that will count how many times a word that is 4 characters long appears in column M?
T TGalin Apr 6, 2009 #2 It works. I tried it out. Thank you. Rick Rothstein said: 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 Click to expand...
It works. I tried it out. Thank you. Rick Rothstein said: 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 Click to expand...
T TGalin Apr 6, 2009 #3 I tried it out and it worked. Thank you. Mike H said: Maybe =SUMPRODUCT(((LEN(A1:A22)=4)+0)*(ISTEXT(A1:A22))) Mike Click to expand...
I tried it out and it worked. Thank you. Mike H said: Maybe =SUMPRODUCT(((LEN(A1:A22)=4)+0)*(ISTEXT(A1:A22))) Mike Click to expand...
T TGalin Apr 6, 2009 #4 This works also. Lean is always better. Rick Rothstein said: 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 Click to expand...
This works also. Lean is always better. Rick Rothstein said: 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 Click to expand...
