View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jasmine Jasmine is offline
external usenet poster
 
Posts: 27
Default Count no of cells containing data for more than one criteria

Hi

Is there any formula, which can retrieve the count of cells in a range which
contains some specific words.
EG: A column contains rose,jasmine,flower,dress,color etc. From this list of
data i need to get the number of cells contains rose, jasmine and color.
Thanks in advance

Regards
jasmine