Anyone please help, how to use countif or countifs with one criteria range and multi cells as criteria in it. I need it cuz there are too many data n many dynamic cells as criteria... Idon't want the "TEXT" as criteria ({"Banana";"Cherry";"Melon"}) ... Thank You for help...

COUNTIFS MULTI.JPG