title: SUMPRODUCT - return a row number
body: <p>I am trying to return the row number in which a sheet Column matches a value AND another column in that same sheet matches a value AND yet another column in that same4 sheet matches a value.</p>
  
  <p>Here is some code:</p>
  
  <pre><code>=SUMPRODUCT((Data!C:C=Total!$A5)*(Data!A:A=Total!E35)*(Data!B:B=Total!F35)*(ROW(Data!C:C)-1))
  </code></pre>
  
  <p>Where Data!C:C is a column of dates and Total!$A5 is a cell with the same format type date
  And Data!A:A is a column of unique text values and Total!E35 is a cell with a text value
  AND Data!B:B is a column of unique text values and Total!E35 is a cell with a text value</p>
  
  <p>There is only one match for the given combination I described.</p>
  
  <p>I am stuck on the latter part of the formula, I believe. Where I multiply the ROW(Data! blah blah blah...</p>
  
  <p>Can somebody help?!</p>