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
|