LinkBack URL
About LinkBacks
Hello all.
I want to count�*a specific�*string "Mr. Tom"�*from a column of data. I am trying the formula "COUNTIF(E1:E4,"*Mr. Tom*")" but it returns 3. My expected return�*is 4. Please�*advise.
COUNTIF.png
Thanks�*in advance.
Regards.
Hello all.
I want to count�*a specific�*string "Mr. Tom"�*from a column of data. I am trying the formula "COUNTIF(E1:E4,"*Mr. Tom*")" but it returns 3. My expected return�*is 4. Please�*advise.
COUNTIF.png
Thanks�*in advance.
Regards.
Try this:
=SUM((LEN(E1:E4)-LEN(SUBSTITUTE(E1:E4,"Mr. Tom","")))/LEN("Mr. Tom"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
You might need to array-enter Glenn's formula (i.e. Ctrl-Shift-Enter, rather than just Enter) if you are using XL2016.
Pete
Many many thanks. It works perfectly.
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks