title: Excel Countif using month and letter as Criteria's
body: <p>I have a list of sales data that includes the date of the sale and also a sales type code. I'm trying to use COUNTIFS to count how many sales of a specific type there were during each month .</p>
  
  <p>So for example:</p>
  
  <pre><code>Date.                  Sales Type Code
  10/01/2014.                 S
  12/01/2014.                 S
  15/01/2014.                 O
  18/01/2014.                 S
  02/02/2014.                 O
  08/02/2014.                 S
  </code></pre>
  
  <p>Would give me the following results:</p>
  
  <pre><code>Code S
  
  January -       3    
  February -      1
  
  Code O
  
  January -       1
  February -      1
  </code></pre>
  
  <p>I have the formula</p>
  
  <pre><code>COUNTIFS('SALES LEDGER'!A:A,F2,'SALES LEDGER'!C:C,"&lt;"&amp;EOMONTH('MONTH Sales by Sales Type'!$C$1,0)+1)
  </code></pre>
  
  <p>Where A:A is the list of Sales Type Codes, F2 is the code I want to count, C:C is the list of dates and C1 is the first of the month I want to count (ie. 01/01/2014).</p>
  
  <p>This works fine for January, giving me the expected result. But when I change C1 to 01/02/2014, it counts January <strong>and</strong> February together, rather than just February.</p>
  
  <p>If anyone has any suggestions it would be appreciated!</p>
  
  <p>Thanks</p>