title: How to calculate the sum of VLOOKUP with two criteria?
body: <p>I'm looking for a clean(er) way (than using <code>SUMIF</code> with a third row) to calculate the sum of the results from, say, a <code>VLOOKUP</code> that checks both the first and the second row for matching criterion.</p>
  
  <p>So, given the Transaction spreadsheet, I'd like to generate the data in the Report spreadsheet - ignoring for the moment how I determine which client/account combinations are relevant in the Report spreadsheet - by adding up the values in Transactions which have the given client and account.</p>
  
  <p><em>Transactions</em></p>
  
  <pre><code>CLIENT         | ACCOUNT        | VALUE
  ---------------|----------------|----------------
  001            | 001            |  25.00
  001            | 001            |   5.00
  001            | 002            |  10.00
  002            | 002            |  23.00
  002            | 002            |   6.00
  003            | 001            |   5.00
  003            | 001            |   1.25
  003            | 001            | 204.00
  003            | 003            |  14.00
  </code></pre>
  
  <p><em>Report</em></p>
  
  <pre><code>CLIENT         | ACCOUNT        | TOTAL
  ---------------|----------------|----------------
  001            | 001            |  30.00
  001            | 002            |  10.00
  002            | 002            |  29.00
  003            | 001            | 210.25
  003            | 003            |  14.00
  </code></pre>