title: How to count records based on subset of data in googlesheet?
body: <p>I have a table of tickets assigned to users. The tickets are either in <em>Open</em>, <em>Closed</em> or <em>Resolved</em> state.</p>
  <p><a href="https://i.stack.imgur.com/FuYZO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FuYZO.png" alt="owner" /></a></p>
  <p>I'm able to create the list of owners using the formula:</p>
  <pre><code>=UNIQUE(D9:D20)
  </code></pre>
  <p>I'm also able to generate the number of total issues against each user using the formula:</p>
  <pre><code>=COUNTIF(D9:D20, A2)
  </code></pre>
  <p>But now I need to calculate the number of <em>Open</em>, <em>Closed</em> or <em>Resolved</em> issues for each individual users.</p>
  <p>Any suggestions please?</p>