title: Can't get sumifs to work with a nested function
body: <p>I have a set of data with one column having product IDs, and another column having the values.</p>
  
  <p>I'm looking to take a sum of the column values, IF the IDs have a 7 or 9 as their 3rd character. I have a formula that I believe is very close, but not there yet:</p>
  
  <pre><code>=SUMIFS(E3:E821,A3:A821,MID(this,3,1)="7",A3:A821,MID(this,3,1)="9")
  </code></pre>
  
  <p>My problem is that I'm using the mid function in the criterias, but I don't know how to give it a variable to reference the current cell being evaluated. If I were programming in JavaScript, I'd use "this" to reference the current object, but that doesn't work in Excel. All of the examples I've been able to find have very simple criteria where you don't reference the cell itself in the comparison, which leaves me at a loss.</p>