title: Using Sumproduct to count how many are between date range in Excel
body: <p>The worksheet is here: <a href="https://dl.dropbox.com/u/3327208/Excel/PAERTO.xlsm" rel="nofollow">https://dl.dropbox.com/u/3327208/Excel/PAERTO.xlsm</a></p>
  
  <p>This is what I am trying to do, I am trying to "count" how many late jobs fall between a set of dates. As far as I remember, Sumproduct() is meant to do that, with some calculations of course thrown in. </p>
  
  <p>I am using it like this: <code>=SUMPRODUCT((H23:H29&gt;='Raw Data'!K2)*(H23:H29&lt;='Raw Data'!K3))</code></p>
  
  <p>This formula <strong>should</strong> calculate the time between today, and a prior, and come back with a response. There should be 1. At least when this was posted. If not, then by tomorrow there will be none. And it should fall with a few others into the Within two Weeks range.</p>
  
  <p>If someone could help me, it be greatly appreciated, because as far as I can tell this is not working the way it should... I am using Excel 2010 btw. </p>