title: Array as criteria in Excels COUNTIFS function, mixing AND and OR
body: <p>I have been googling this for a while and can´t seem to get it to work. I use Excel 2010 and want to count rows on a mix of AND and OR operators.</p>
  
  <p>What I want to do is something like this</p>
  
  <pre><code>COUNTIFS($A:$A,"string1" , $B:$B,"string2" , $C:$C,{"stringA","stringB","stringC"})
  </code></pre>
  
  <p>This means mixing both AND and OR operator in the COUNTIFS function. Col A and col B must match the string criteria but col C must only match one of the values in the array given as criteria. Match on colA AND colB AND on one array value in col C.</p>
  
  <p>A different approach would be to create one COUNTIFS function for each value in the array like</p>
  
  <pre><code>COUNTIFS($A:$A,"string1" , $B:$B,"string2" , $C:$C,"stringA") + COUNTIFS($A:$A,"string1" , $B:$B,"string2" , $C:$C,"stringB") + COUNTIFS($A:$A,"string1" , $B:$B,"string2" , $C:$C,"stringC")
  </code></pre>
  
  <p>This however is a lot of duplicate code and that bugs me! The logic solution would be to pass an array as criteria for column C. Also my array contains more then three values...</p>
  
  <p>When I do this in Excel the formula is accepted and a few rows are counted but the results are way to low. It is not the result I´m expecting.</p>
  
  <p>Any Excel-Pro out there that can tell me if this is possible? It would save me a lot of work!
  Thanks!</p>