title: Group by two columns and count and then compare
body: <p>I have data in Excel that looks like this:</p>
  <pre><code>ID  DATE        COST    TOTAL
  1   01-01-18    50      100
  1   01-01-18    25      100
  1   01-01-18    25      100
  2   01-03-18    25      100
  2   01-03-18    25      100
  2   01-03-18    50      100
  1   02-01-18    100     100
  </code></pre>
  <p>I want to group by ID and Date then count the cost and ensure it quals to the total for that ID and date. So for example ID 1 and date 01-01-18 I want to count the 50 and 25 and 25 and compare it to 100 to return a true or false.</p>
  <p>How can I do this?</p>