title: Formula for computing total amount per day
body: <p>I have this Excel spreadsheet where in one of the columns I need to come up with a formula that will compute the total amount for a given day. This is a small snapshot of a huge spreadsheet:</p>
  
  <pre><code>Date/Time   Time    Amount      Balance       Total $ per day
  9/30/2014   5:30 PM $5.20       $87.81  
  9/30/2014   4:23 PM $0.14       $93.01  
  9/30/2014   8:53 AM ($4.61)    $93.15   
  9/30/2014   7:53 AM $5.20       $88.54  
  9/29/2014   5:08 PM $1.09       $93.74  
  9/29/2014   7:18 AM $1.09       $94.83  
  9/26/2014   5:31 PM ($4.61)     $95.92  
  </code></pre>
  
  <p>For this example the <code>Total $ per day</code> would be:</p>
  
  <pre><code>E2 $5.93 
  E6 $2.18 
  E8 ($4.61)
  </code></pre>
  
  <p>I'm guessing there is a formula that is much better than manually computing this by <code>=SUM(X#:X#)</code>?</p>