title: Google Spreadsheet SUMIF Date Comparison
body: <p>I'm trying to get this aggregate date comparison working, and I thought I understood the syntax, but it's clearly not working.  Can anyone correct the formula for me?</p>
  
  <p>I'm trying to sum up the amounts in column I, where the date in H is prior to the date in A</p>
  
  <p>My formula is  <code>=SUMIF(H$2:H,H$2:H&lt;A4, I$2:I)</code></p>
  
  <p><img src="https://i.stack.imgur.com/nD1YQ.png" alt="enter image description here"></p>