Countifs if the text to be counted is within or inside a word in a cell (dropdown list)

[kingripper]

Experts,

Need your assistance, I need to do countif to a word containing specific text from a word(ex. dogcatmouse) need to find and count cat (as criteria 1 in a dropdown list)


dogcatmouse 2-Dec
dogcatmouse 2-Feb
dogcatmouse 2-Dec
dogcatmouse 2-Feb


Please see sample attached for reference


thanks,

[Shareez Saleem]

Please Login or Register  to view this content.

[AliGW]

Try this:

=SUMPRODUCT((B15:B22=LOOKUP(1000,SEARCH(F15,B15:B22),B15:B22))*(TEXT(C15:C22,"mmmm")=E15))

[bebo021999]

I think "--" do not need:

=SUMPRODUCT((TEXT($C$15:$C$22,"mmmm")=E15)*(ISNUMBER(SEARCH(F15,$B$15:$B$22))))

[kingripper]

Please Login or Register  to view this content.

thank you very much..

[AliGW]

You had three working solutions offered, but have acknowledged only your first helper here ... But thanks for the rep.

[kingripper]

Thank you very much guys.. all the best....