title: EXCEL: How to get sumproduct of two columns that is filterable
body: <p>I have two different sheets in one workbook. One has the allotted time by month for each resource and the other has the rates by month for each resource.</p>
  
  <p>I am using this formula:</p>
  
  <pre><code>=SUMPRODUCT(Test!F2:F12,Rates!C2:C12)
  </code></pre>
  
  <p>This gets me the total monthly value for each row multiplied by the corresponding rate on the other worksheet.</p>
  
  <p>What I'm trying to do is make the total dynamic when I use the filters.</p>