title: Calculating total monthly precipitation values using SUMIF function to specify date window
body: <p>I've got an excel sheet with dates in one column (daily) and total precipitation values for that date in another column from 01/01/2000 to 31/12/2021.</p>
  <p>I want to calculate the total monthly precipitation values from 2000 to 2021.</p>
  <p>The formula I have been using after some research online was (which I was planning on iterating over the months):</p>
  <pre><code>=SUMIFS(B2:B8036,C2:C8036,&quot;&lt;=&quot;&amp;DATE(2003,9,1),C2:C8036,&quot;&gt;=&quot;&amp;DATE(2003,9,30))
  </code></pre>
  <p>The values I want to sum (precipitation) are in the B column, the dates are in the C column. However, I get a zero value returned in the cell when I run the formula, even though the actual value should be 131.94.</p>
  <p>I'm not sure what mistake I made in my formula.</p>