title: Count days worked per employee number in Excel
body: <p>I have a timesheet entry form that people use to enter their hours worked per day. Sometimes they enter multiple entries per day because of different areas worked.</p>
  
  <p>I want to count how many days worked based on the work date. There could be multiple entries per workdate.</p>
  
  <p>For example:</p>
  
  <pre><code>Employee #       Date          Hours
  12345            11/15/17      8
  12345            11/16/17      4
  12345            11/16/17      3
  98765            11/15/17      2
  98765            11/15/17      2
  98765            11/15/17      2
  </code></pre>
  
  <p>I have a consolidated table that sums the hours worked per employee, but I also would like the days worked. So, for example:</p>
  
  <pre><code>Employee #       Hours         Days
  12345            15            2
  98765            6             1
  </code></pre>
  
  <p>I can't seem to put my finger on the right formula/combination of formulas to use. Countif would work perfectly if it worked similarly to sumif.</p>