title: Excel Sum If Year Equals
body: <p>I got two columns of data;</p>
  
  <p>A:</p>
  
  <p>12/31/2013</p>
  
  <p>12/30/2013</p>
  
  <p>12/29/2013</p>
  
  <p>12/28/2013</p>
  
  <p>12/27/2013</p>
  
  <p>12/26/2012</p>
  
  <p>B:</p>
  
  <p>10</p>
  
  <p>10</p>
  
  <p>10</p>
  
  <p>10</p>
  
  <p>10</p>
  
  <p>5</p>
  
  <p>my formula is : =SUM(IF(YEAR(G6:G11)=2013,H6:H11,0),0)</p>
  
  <p>in the wizard the answer is 50</p>
  
  <p>but when I hit enter, it displays 55 on the page.</p>
  
  <p>Any thoughts?</p>
  
  <p>SOLUTION:
  While writing formula, press "ctrl + shift + enter"
  Thank you</p>