title: Sumifs to Pivot Tables (Excel 2016)
body: <p>My current role maintains and updates reports created in Excel. I'm on the process of cleaning the source sheets for the dashboard. </p>
  
  <p>I want to create a pivot table based on the table below: </p>
  
  <pre><code>Record (A) | Created_Month (B) | Report_Month (C)
  Entry 1    | Feb-17            | May-17
  Entry 2    | Mar-17            | May-17
  Entry 3    | Apr-17            | May-17
  Entry 4    | May-17            | May-17
  Entry 5    | May-17            | May-17
  Entry 6    | May-17            | Jun-17
  Entry 7    | Apr-17            | Jun-17
  Entry 8    | Jan-17            | Jun-17
  Entry 9    | Feb-17            | Jun-17
  Entry 10   | May-17            | Jun-17
  Entry 11   | Jun-17            | Jun-17
  Entry 12   | Jun-17            | Jun-17
  </code></pre>
  
  <p>So we receive an Excel file with data table similar above. I just need to report the number of entries created on the same month as the reporting month. So for example, for Jun-17, there are 2 entries created. Using COUNTIFS, this data could be extracted but I want to do it in Pivot tables with Reporting_Month as the column. Any suggestions? </p>