title: Excel count number of values based on another column
body: <p>I want to count the number of times a value appears based on the criteria in another column. Eg, for the example below I want to search the data and lookup how many times ART has a 2 and a 3, etc. I want to display these results on a separate worksheet</p>
  
  <p><a href="https://i.stack.imgur.com/cbOND.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cbOND.png" alt="enter image description here"></a></p>
  
  <p>Thanks in advance</p>