title: Sum value based on multiple criteria including name and > and < date range
body: <p>I am trying to create a formula in Excel that automatically calculates the total value from a range based on a number of criteria across multiple sheets in a workbook. I am working in two different sheets: </p>
  
  <p>Here is a link to view the workbook: <a href="https://docs.google.com/spreadsheets/d/1vf-wcaVokKr7apkoibM7Vx-q2MYJkmLlDl8wsKW8TVo/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1vf-wcaVokKr7apkoibM7Vx-q2MYJkmLlDl8wsKW8TVo/edit?usp=sharing</a>  </p>
  
  <p><strong>Sheet 1</strong> contains all my input data:</p>
  
  <ul>
  <li>Forecast $</li>
  <li>Description</li>
  <li>Start Date</li>
  <li>End Date</li>
  </ul>
  
  <p><strong>Sheet 2</strong> is the client facing report that contains: </p>
  
  <ul>
  <li>Category </li>
  <li>Date range (weekly breakdown of a financial year)</li>
  <li>Total values</li>
  </ul>
  
  <p>In the Total Values column of Sheet 2 I want to automatically sum:</p>
  
  <p><strong>Sheet 1 Forecast $</strong> based on <strong>Sheet 1 Description = Sheet 2 Category</strong> but only for the date range where <strong>(Sheet 1 start date is (>= Sheet 2 beginning of week date range and &lt;= Sheet 2 end of week date range)</strong></p>
  
  <p>The calculation needs to be applied across 4 different categories and 52 different start and end date weeks in Sheet 2. </p>
  
  <p>Is this possible?</p>