title: Excel: Find all values in a list that match another list as part of a COUNTIFS Statement
body: <p>I'm struggling with integrating a condition into my COUNTIFS statement. I have about 5 conditions which I've been able to easily work in, but I can't figure out the last one. The criteria range would be A1:A40000, and the criteria would count the number that match any value in a list of 30 text strings on Sheet 2, Cells A1:A40. Is this possible? I can get the result without the other conditions. Unfortunately, I do not have the flexibility to add a column next to A1:A40000 that checks to see if it is in the list.</p>
  
  <p>Edit: Clarification per request.</p>
  
  <p>Simplified version of what I'm doing. I need to count the number items (column A) that meet several conditions depending on the column in the entire data set. So, I need to find the number of items that have a value of "1" in column B - AND - a value of "YES" in column "C" - AND - a value of "OLD" in column "D" - AND - (the part I'm struggling with) column "E" must contain any one of the values that's in a completely separate range (call it Z1:Z40). The formula for the first 3 conditions would be:</p>
  
  <pre><code>=COUNTIFS(B:B,1, C:C,"YES", D:D,"OLD")
  </code></pre>
  
  <p>The final criteria in bold would be something like:</p>
  
  <pre><code>=COUNTIFS(B:B,1, C:C,"YES", D:D,"OLD",  **E:E,isnumber(match(E:E,Z1:Z40,0))**)          
  </code></pre>
  
  <p>But that does not work...</p>