title: IF (Condition) and (another condition) increment cell
body: <p>I have two spreadsheets:</p>
  
  <p>First One :</p>
  
  <pre><code> **Type**   **Quantity**
    Games        1 
    Games        1
    Games        2
     DVD         1
  </code></pre>
  
  <p>Second one :</p>
  
  <pre><code> **Type**   **Increment**  
      DVD
     Games
  </code></pre>
  
  <p>I want a nested IF statement in <code>Second one</code> that, if <code>Type</code> is <code>DVD</code>, will sum the corresponding <code>Quantity</code> values from <code>First One</code>, and similarly for <code>Games</code>. The expected results for my example are <code>1</code> and <code>4</code> respectively.</p>
  
  <p>Any help will be much appreciated!</p>