Inside the left SUMPRODUCT, SEARCH looks for all strings in the named range “include”.
In the right SUMPRODUCT, SEARCH looks for all strings in the named range “exclude”.
SEARCH Function
The Excel SEARCH function returns the location of one text string inside another.
SEARCH returns the position offind_textinsidewithin_textas a number.
SEARCH supports wildcards, and isnotcase-sensitive….
