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!
Bookmarks