Hello,
I've attached a sample of my work. I would like to count the number of cells having the character string "no DNA-profile". I've been using the formula as explained in another post, which generic is: =SUMPRODUCT(LEN(rng)-LEN(SUBSTITUTE(rng,txt,""))).
However, that has not worked correctly for me as shown in cell B1, where the count should be 1 instead of 14.
Can somebody help me with this issue? Hope this question is still interesting!
You can use a simple COUNTIF for this:
=COUNTIF($A$1:$A$8,"no DNA-profile")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Try this: =SUMPRODUCT((LEN(rng)-LEN(SUBSTITUTE(rng,txt,"")))/LEN(txt))
Click the * to say thanks.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks