title: Dynamically calculated the sum of a filtered column on another sheet in excel
body: <p>I have two sheets in Excel. </p>
  
  <p>On one sheet, I have a table containing a date, a description and a number value. </p>
  
  <p>For example:</p>
  
  <pre><code>1/11/2014 Groceries 23.54
  1/12/2014 Dining    36.99
  1/18/2014 Groceries 45.55
  1/20/2014 Movies    12.99
  1/20/2014 Dining    40.24
  </code></pre>
  
  <p>In my second sheet, I want to have a row that dynamically calculates the sum of all the values with the a specific description.</p>
  
  <pre><code>Groceries : 69.09
  Dining : 77.23
  Movies : 12.99
  </code></pre>
  
  <p>Is there a way to do this without VBA?</p>