View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RH RH is offline
external usenet poster
 
Posts: 17
Default functions/Formulas

I have multiple worksheets and I would like to count the number of times
certain words appear in each worksheet and group them by area. I then want
to count how many times a number appears based on those words.

example: Apple, orange, peas, carrots
I want to count Apples and oranges in all worksheets and then count how many
of them are available.