title: Sum numbers by date and by ID in Excel
body: <p>I have a very large (lets say, 100,000 rows) excel table that has <strong>some</strong> (there are others) columns in it:</p>
  
  <pre><code>Person ID |   Date   | Number |
  0043       03/20/2006  6
  0043       03/20/2006  3.21
  1478       04/01/2006  9.87
  0021       04/12/2006  0.23
  0101       04/12/2006  3.14
  1042       04/12/2006  11.13
  </code></pre>
  
  <p>What I would like to do is go through the table and add up the numbers, by date, for the given person ID.  Meaning:  right now some entries are listed twice for the same date, but I would really like a "sum" of those number values for that person on that date (not two separate rows).</p>
  
  <p>Later, I am going to run some analysis on those "summed results", like, "how many people have a number over 3 but under 6", etc.</p>
  
  <p>Is there a simple function I can run that will sum up the values by date by person ID, and give me a new column to display the resulting sum in?  OR, is there a VB program that will do this with ease?</p>
  
  <p>Ultimately, I'm hoping to have a new column to display the results in, this new table would look like the following:</p>
  
  <pre><code>Person ID |   Date   | Number | Total Per ID Per Date |
  0043       03/20/2006  6        9.21
  0043       03/20/2006  3.21     N/A
  1478       04/01/2006  9.87     9.87
  0021       04/12/2006  0.23     0.23
  0101       04/12/2006  3.14     3.14
  1042       04/12/2006  11.13    11.13
  </code></pre>
  
  <p>Any thoughts/suggestions?  Visual Basic or chain an excel function?  For simplicity of given answers, lets assume Columns (Person ID, Date, etc) are A-C (or A-D, in the case of the resulting table) and of course rows 1-7.</p>
  
  <p>Thank you!</p>