Counting comments
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
|