title: How to sum entries that have same ID OpenOffice - Calc
body: <p>I have a spreadsheet similar to the one in the screenshot.
  <img src="https://i.stack.imgur.com/21hOQ.jpg" alt="Current Data"></p>
  
  <p>From this I want to sum all the entries in Data 2 which have the same Data 1 ID and store it in another column. So something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/Cd4LT.jpg" alt="The end result"></p>
  
  <p>I am not able to figure out the formula which would do this. I figured out how to get a column with unique entries I just need to figure out how to get the sum of the values which have the same data 1 id. </p>
  
  <p>Can someone point me in the right direction?</p>