Counting comments

B

Byron720

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
 
M

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
Click to expand...

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 ";"
 
Top