title: sum of all transactions if date = June
body: <p>I have a list off transactions with the date in column B and total amount for the transaction in column I. I want to have a cell that contains sum total of all transactions in the month of June of year 2011. However, the dates in column B may not be all in June, so I need to filter months that are June and then add all the values for each transaction of that month. </p>
  
  <p>My thinking, <code>=IF(DATE(2011,06,*),SUM(VLOOKUP(.....), Null))</code>
  , <code>=SUM(IF(B=Date(2011,06,*))</code></p>
  
  <p>Can you help me out please?</p>
  
  <p>Thank you</p>