title: SUMIF/SUMPRODUCT match multiple criteria within date range
body: <p>I have a <a href="https://i.stack.imgur.com/LZ47o.jpg" rel="nofollow noreferrer">table (Sales)</a> data that has two sets of columns with code, amounts and date reference:</p>
  
  <p><a href="https://i.stack.imgur.com/LZ47o.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LZ47o.jpg" alt="enter image description here"></a></p>
  
  <p>And I have another <a href="https://i.stack.imgur.com/S94PM.jpg" rel="nofollow noreferrer">table (Sheet1)</a>:<br>
  <a href="https://i.stack.imgur.com/S94PM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S94PM.jpg" alt="enter image description here"></a>
  which need to sum the total net amount with one set subtract the other set on the <strong>Sales</strong> table but it have to matched the code and based on the weekly date range in <strong>Sheet1</strong> table. I can sum the total amount together but I can't separate it with date.</p>