title: How to sum data in one column based on the same month in another column using macros
body: <p>I am using macros in excel 2007 for my work. I am working with many data and I need to sum data from 2 or more rows in the same coloumn according to the same month. However the month column is expressed as date.</p>
  
  <p>for example, i have series of data</p>
  
  <pre><code>A            B
  2/10/2008    2
  2/10/2008    3
  4/10/2008    3
  5/11/2008    4
  5/11/2008    5
  </code></pre>
  
  <p>I want the result to be displayed in column C and D as followed</p>
  
  <pre><code>C            D
  Oct/08       8
  Nov/08       9
  </code></pre>
  
  <p>I am very thankful if anyone can help me.</p>
  
  <p>regards,</p>
  
  <p>Tifu</p>