Hi,
I've trying to develop the search function in formula which it bring innocent result or zero. So I hope you will able to help. So one example of line of code which I've used in SUMPRODUCT, for example.
(ISNUMBER(SEARCH({"Rottweiller", "Beagle", "Bulldog", "Greyhound", "Poodle"},'Dog...