title: Summing Duplicates in Excel
body: <p>I have a long list of names of products and numbers of those products, I want to combine all the duplicate entries and add their numbers. So if I have 2 entries for Widget X, and each entry has 3 products, then I want to combine this to one entry for Widget X with 6 products.</p>
  
  <p>I've sorted the list out and summed them for each product but I just used a sum function, I felt there must be a formula that uses an IF statement to detect entries that equal each other and then sum their respective quantity lines but I can't figure it out.</p>
  
  <p>What i'm trying to get is IF (any field in column A = 3792 , then sum all its associated quantity fields in column C)</p>
  
  <p>Does anyone have any ideas?   </p>
  
  <pre><code>3792    Widget A    1
  3792    Widget A    1
  3792    Widget A    1
  3792    Widget A    1
  3792    Widget A    1
  3792    Widget A    2
  3792    Widget A    1
  3805    Widget B    1
  3805    Widget B    1
  3806    Widget C    8
  3823    Widget D    895
  3823    Widget D    1
  3823    Widget D    20
  3892    Widget E    2
  3892    Widget E    1
  3892    Widget E    1
  </code></pre>