title: How to add data based on dates?
body: <pre><code>10/3/2016   -27
  10/3/2016   -2.13
  10/3/2016   -12.82
  10/3/2016   -7.25
  10/3/2016   -4.5
  10/3/2016   -19.23
  10/3/2016   -1.93
  10/3/2016   -10.7
  10/3/2016   -63.08
  10/3/2016   -12.82
  10/3/2016   -10.6
  10/3/2016   -14.72
  10/3/2016   -14.96
  10/4/2016   -152.5
  10/4/2016   -6.73
  10/4/2016   -12.99
  10/4/2016   -4.8
  10/4/2016   -16.76
  10/4/2016   -8.54
  10/4/2016   -7
  10/4/2016   27
  10/5/2016   93.67
  10/6/2016   -8.07
  10/7/2016   0.01
  10/7/2016   -565.27
  10/7/2016   -16.25
  10/7/2016   1690.7
  </code></pre>
  
  <p>I have a calendar spreadsheet and I want each date to hold the SUM of all the values for the above.</p>
  
  <p>For example</p>
  
  <pre><code>10/1/2016 - $0 (because no data is present)
  10/2/2016 - $0
  10/3/2016 - (Sum of all dates that are 10/3)
  </code></pre>
  
  <p>I do not know the number of transactions that appear. So there could be 0 or 30.</p>
  
  <p>I am using Excel 2016 (64-bit) on Windows 10 (64-bit) </p>