title: Graphs and Grouping with SUMIF?
body: <p>In one column, I have a day column, eg. Monday, Tuesday, Wednesday
  In another column next to it, I have a number value. (eg. $2000, $5000, $6000)
  eg.</p>
  
  <pre><code>__DATE__________VALUE____
  Monday      |  $5000
  Monday      |  $9000
  Tuesday     |  $2000
  Wednesday   |  $6000
  Wednesday   |  $6000
  </code></pre>
  
  <p>These values will <strong><em>change periodically</em></strong>.</p>
  
  <p>I need to insert a graph, that displays the grouped values. 
  eg. At current point, the graph shows:</p>
  
  <pre><code>Monday       $5000
  Monday       $9000
  Tuesday      $2000
  Wednesday    $6000
  Wednesday    $15000
  </code></pre>
  
  <p>I need the graph to instead show the same values, but grouped by DAY:</p>
  
  <pre><code>Monday    $14000
  Tuesday   $2000
  Wednesday $21000
  </code></pre>
  
  <p>As I said, both the day and the value next to it will change when need be, so I would prefer this to be grouped automatically with some sort of forumla. </p>
  
  <p>Is there any way to do this?</p>
  
  <p>I have had a read on the SUMIF function, but can't seem to make it work with this.</p>