title: Trying to find a way to SUM a field based on criteria looked up in different table in excel
body: <p>See below tables for data. I am trying to answer the question &quot;What is the total QTY of items classified as Fruit?&quot; in a singular formula.</p>
  <p>Table 1</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Product</th>
  <th>QTY</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple</td>
  <td>5</td>
  </tr>
  <tr>
  <td>Apple</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Banana</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Carrot</td>
  <td>5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table 2</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Product</th>
  <th>Class</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apple</td>
  <td>Fruit</td>
  </tr>
  <tr>
  <td>Banana</td>
  <td>Fruit</td>
  </tr>
  <tr>
  <td>Carrot</td>
  <td>Veg</td>
  </tr>
  </tbody>
  </table>
  </div>