NB.SI with partial text

Solved
nice -  
 nice -
Hello,

I need your help regarding a detail about the COUNTIF function.

When I want to check if a range contains certain text (typed manually), the function works well.
--> Example: =COUNTIF(F2:F108,"*University initial training*")

However, when instead of typing manually, I want to refer to the cell that contains the same text, it doesn't work completely.
--> Example: =COUNTIF(F2:F108,A37)

Indeed, when the phrase in the range ends with a period, comma, or other punctuation, it isn't counted... I would like it to be. How can I do that?

It's not easy to explain, I hope I am understood.

Thank you in advance for your help.

1 réponse

yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   Ambassadeur 1 587
 
Hello, what did you put in A37?
Can you give some examples?
Maybe:
=COUNTIF(F2:F108,"*"&A37&"*")
0
nice
 
Super ! It's exactly what I was trying to do :) I hadn't locked the cell with all those characters
Thank you a thousand times!
0