title: searching for multiple strings in a column excel
body: <p>I've seen this question answered a few times but none of the solutions are working for me and I'd like to understand why.</p>
  
  <p>I have the following:</p>
  
  <pre><code>=SUMPRODUCT(sheet1!$E$2:$E$228714,--(sheet1!$F$2:$F$228714="someword"), --(ISNUMBER(FIND({"word1","word2"},sheet1!$C$2:$C$228714))))
  </code></pre>
  
  <p>When in the third parameter of the function I only leave 1 word within the curly braces, it works great, but if I add "word2" in there, I get #VALUE! back.</p>
  
  <p>I want to be able to FIND multiple words. Basically the third parameter would return 1 or 0 depending on whether it finds the specified words or not for every single cell in that row.</p>