title: Excel SUMIF between dates
body: <p>I have column A with date values formatted as <code>mm/dd/yyyy</code>.  I am trying to sum the values of column B if A >=DATE(2012,1,1) AND 
  
  <p><code>=SUM(B:B)</code> sums B properly, but if I try to use <code>=SUMIF(B:B,A:A&gt;=DATE(2012,1,1))</code> the value returned is <code>0.00</code>.  I'm assuming this has something to do with using decimal for the sum and date type for the criteria.  Is there a way to get around this?</p>
  
  <p>Thanks</p>