title: Count number of occurrences by month
body: <p>I am creating a spreadsheet with all my data on one sheet and metrics on the other.</p>
  
  <p>On sheet 1 in cells <code>A2:A50</code> I have the dates in this format (4/5/13). On sheet 2 in cell <code>E5</code> I have April and I want it to total the number of PO's created in F5.</p>
  
  <p>How can I do this?</p>
  
  <p>I have tried using </p>
  
  <p><code>=COUNTIF('2013'!$A$2:$A$50,'2013 Metrics'!E5)</code>. </p>
  
  <p>I have a feeling that since my range is in 4/5/13 format and my criteria is April that won't work.</p>
  
  <p>I was able to use this formula for total spend by month: </p>
  
  <p><code>=SUM(IF(MONTH('2013'!$A$2:$A$19)=4,'2013'!$D$2:$D$19,0))</code> </p>
  
  <p>but not luck with how many PO's by month.</p>