title: Comparing a specific set of numbers
body: <p>I have a google spreadsheet that has 6 cells with specific numbers in them.  Every week, a series of numbers is entered in and I would like to flag the numbers in a separate column if they appear for that week.  I was using the formula below where my numbers are in D2->I2 and the weekly ones would be in D18->I18 for example.</p>
  
  <pre><code>=arrayformula(sumproduct((D2:I2=D18:I18)))
  </code></pre>
  
  <p>Now, while this works, it's not quite what I'm trying to do.  Unless the numbers match each other exactly, 1 2 3 4 5 6 to 1 2 3 4 5 6 then the addition doesn't happen.  What I would like to have happen is that if, for example, the master column has 1 2 3 4 5 6 and the weekly column has 3 7 9 1 8 5 then the cell with the formula would display the value of 3 for matching three of the numbers that week.  </p>
  
  <p>Does anyone have a suggestion on how best to accomplish this?</p>