title: Excel Formula to sum value if date falls in particular month
body: <p>I am trying to make a table in excel which calculate sum of some values if a date falls in a particular month.</p>
  
  <p><img src="https://i.imgur.com/lNFyqPV.png" alt="Image to my spreadsheet"></p>
  
  <p>On the column A are dates, on column B some values, on column E are only listed numbers from 1 to 12 and in column F there are cells with <code>=SUM(IF(MONTH($A$1:$A$10)=E11; $B$1:$B$10; 0))</code> formula.</p>
  
  <p>I dont really know why on <code>F9</code> the value is 0 even if checked with the debuger (F9 key) and saw that the result of the foruma is 22, which is the expected value. Also, I dont know why on <code>F11</code> and <code>F12</code> I receive an error: <code>A value used in the formula is of the wrong data type</code></p>
  
  <p>What can I do to solve this problems? Thank you</p>