title: Excel Formula to SUMIF date falls in particular month
body: <p>I have excel data in following format.</p>
  
  <pre><code>Date        Amount
  
  03-Jan-13   430.00 
  25-Jan-13   96.00 
  10-Jan-13   440.00 
  28-Feb-13   72.10 
  28-Feb-13   72.30
  </code></pre>
  
  <p>I need to sum the amount field only if the month lies in <strong>Jan</strong> Month.</p>
  
  <p>What i have tried is ,</p>
  
  <pre><code>=SUMIF(A2:A6,"MONTH(A2:A6)=1",B2:B6)
  </code></pre>
  
  <p>But it returns, </p>
  
  <pre><code>0
  </code></pre>
  
  <p>What i need is,</p>
  
  <pre><code>Following values to be summed, 430.00 + 96.00 + 440.00 = 966.00
  </code></pre>