title: Google Sheets: Using ArrayFormula to COUNTIF depending on DATE in RANGE
body: <p>Okay so I have two formulas I would like to use together, one I use to 'SUM' the total of projects from the day before:</p>
  
  <pre><code>=ArrayFormula(SUM(1*(INT(Archive!M3:M)=Today()-1)))
  </code></pre>
  
  <p>This will count all projects done from the day before.</p>
  
  <p>Now I have several different types of projects, I use the following formula to separate project types and give a grand total: </p>
  
  <pre><code>=COUNTIF('V1 Archive'!D:D,"25A")
  </code></pre>
  
  <p>What I would like to do is be able to 'SUM' the total of a specific project from the day before.</p>
  
  <p>A few more details:</p>
  
  <p>The data is plain text project codes ex; 25A, 25B, 25C etc..
  The date is formatted like; 6/3/2014 16:41:36</p>