Finally, SUMPRODUCT returns the sum of all items in the array.
Any result greater than zero returns TRUE.
COUNTIF can be used to count…
Range contains one of many substrings
To test a range and determine if it contains one of many substrings (partial matches, specific text, etc.) you can use a formula based on the COUNTIF function nested in the SUMPRODUCT function.
