title: SUMIFS for text and date
body: <p>I am looking to return the sum of C (price) using the layout shown in J,K,L by month.  The lookup would be by customer (3M) and Part Group (420) for this example.  Every month should return zero for 3M expect August should read $255.</p>
  
  <p>Please help and see what I am missing</p>
  
  <p><a href="https://jxmfinancial.files.wordpress.com/2017/08/helptest.png" rel="nofollow noreferrer"><img src="https://jxmfinancial.files.wordpress.com/2017/08/helptest.png" alt="Sample layout"></a></p>