View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Byron720 Byron720 is offline
external usenet poster
 
Posts: 61
Default 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