title: Combining COUNTIF and VLOOKUP
body: <p>This is what I'm trying to do. There are two columns. The first one contains the drawing number of a P&amp;ID and The other one contains the IO type. Columns B and N respectively. I want the number of DOs for the drawing number ZCPL-P2179-B1-101. I know a simple COUNTIF function works but it is inefficient since rows keep expanding and it is quite tedious to constantly reselect the ranges.</p>
  
  <p><img src="https://i.stack.imgur.com/GLq1i.png" alt="For example, "></p>