Counting comments

[Guest]

I have a report where one of the columns is "Comments". Let say one of them
says : This part is unavailable. The report is really big and so are the
range of comments. What I need is a formula that calculates for example how
many of the comments have the word unavailable. I tried VLOOKUP, IF, COUNTIF,
but they don't seem to work (as far as I know). Please help

 

[Mladen_Dj]

I have a report where one of the columns is "Comments". Let say one of them
says : This part is unavailable. The report is really big and so are the
range of comments. What I need is a formula that calculates for example how
many of the comments have the word unavailable. I tried VLOOKUP, IF, COUNTIF,
but they don't seem to work (as far as I know). Please help

Use asterisk (*) in COUNTIF. Let's say coments are in range C1:C25,
formula:

=COUNTIF(C1:C25;"*unavailable*")

will return number of coments which contains word "unavailable".
Maybe you will must to change argument separator, because in my local
setings it is ";"