title: Sum Excel Distinct Values
body: <p>I know how to do this with MySQL, but am at a loss as to how (or even if possible) within MS Excel.  I am running Excel version 14 on Windows (part of Office Professional 2010).</p>
  
  <p>I have a table with two columns...for example one containing phone numbers and the other containing integers (length of phone calls).  There are multiple calls from each phone number, so those numbers would likely appear multiple times.  I am trying to SUM the total number of minutes per distinct phone number.  How can I do this in Excel?</p>
  
  <pre><code>-------------------------
  |  number  |  duration  |
  -------------------------
  | 1234567  |  8         |
  | 2345671  |  5         |
  | 1234567  |  12        |
  | 3456712  |  5         |
  | 3456712  |  47        |
  | 1234567  |  15        |
  | 1234567  |  4         |
  -------------------------
  </code></pre>
  
  <p>So the end result would be something like:</p>
  
  <pre><code>-------------------------
  |  number  |  duration  |
  -------------------------
  | 1234567  |  39        |
  | 2345671  |  5         |
  | 3456712  |  52        |
  -------------------------
  </code></pre>
  
  <p>Thanks!</p>