title: Excel: SUM multiple lines by YEAR
body: <p>I need a formula to sum the amount of dividends payed per year.</p>
  
  <p>Column A shows the date and column B shows the amount payed.</p>
  
  <p>Example of my data: <a href="https://i.stack.imgur.com/layJy.png" rel="nofollow noreferrer">https://i.stack.imgur.com/layJy.png</a></p>
  
  <p>I've tried IF with SUM, SUMIF, VLOOKUP, etc., but no success.</p>
  
  <p>Thanks.</p>