title: Excel SUMIF for dates within a certain month
body: <p>My question is directly related to <a href="https://stackoverflow.com/questions/15285381/excel-formula-to-sumif-date-falls-in-particular-month">Excel Formula to SUMIF date falls in particular month</a>, but I can't get my formula to work based on the answers there.  </p>
  
  <p>My very simple worksheet looks like this:</p>
  
  <pre><code>MONTH        INCOME 
  January      {formula goes here and in subsequent rows}
  February    
  March       
  April       
  May     
  {&amp;c. for all 12 months}
  </code></pre>
  
  <p>I'm trying to get a sum of values in column E from another sheet, called "Worklog", calculating the income total per month.  </p>
  
  <p>The “Worklog” sheet is formatted like so:</p>
  
  <pre><code>(A)         (B)             (C)             (D)         (E)
  DATE        EMPLOYER        DESCRIPTION     AMNT DUE    AMNT REC'D
  01/01/17    Employer Name   Project Name    $100         $100 
  02/09/17    Employer Name   Project Name    $100         $300 
  03/11/17    Employer Name   Project Name    $100         $100 
  04/12/17    Employer Name   Project Name    $100         $100 
  07/16/17    Employer Name   Project Name    $200         $200 
  </code></pre>
  
  <p>I've tried the following, all as array formulas (by entering the formula and hitting Control-Shift-Enter as instructed in the other post):</p>
  
  <pre><code>=SUMPRODUCT( (MONTH(Worklog!$A$2:$A$250)=MONTH(A2)) * (Worklog!$E$2:$E$250) 
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=SUM(IF(MONTH(Worklog!$A$2:$A$250)=MONTH(A2),Worklog!$E$2:$E$250,0))
  =SUM(IF(MONTH(Worklog!$A$2:$A$250)=1,Worklog!$E$2:$E$250,0))
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=SUMPRODUCT( (MONTH(Worklog!$A$2:$A$250)=1) * (Worklog!$E$2:$E$250) )
  </code></pre>
  
  <p>Although the Date columns are formatted differently (“mmmm” vs “dd/mm/yy”), they are both Date type columns.
  The Worklog does contain data for all twelve months.</p>
  
  <p>Where am I going wrong?</p>
  
  <p>I’m running Microsoft Excel for Mac (Version 15.33), in case that makes any difference in how the formulas are written.</p>
  
  <p>Thanks in advance for your help!</p>