title: Count How Often One List Item is Found in Another List
body: <p>I have 3 sheets.</p>
  
  <p><strong>Sheet 1</strong> has a column, with the named range <strong>PayCode,</strong> of about 200 records, each containing a string. Each cell only contains one specific string, but each string can be found in multiple cells. A few of these strings represent if an employee is absent.</p>
  
  <p><strong>Sheet 2</strong> has a list of six unique strings of interest, with the named range <strong>Absent</strong>. These six strings are the possible Pay Codes that represent if an employee is absent, and they are what I am looking for in the <strong>PayCode</strong> column.</p>
  
  <p>On <strong>Sheet 3,</strong> I would like to count how many times a string from <strong>Absent</strong> is found in <strong>PayCode</strong>.</p>
  
  <p>Every suggestion I've found online has me doing a <code>COUNTIF</code> next to the list on <strong>Sheet 2</strong> to count how often each list item shows up, but I just want a count in one cell on <strong>Sheet 3</strong> of the total number of appearances of <strong>Absent</strong> list items in the <strong>PayCode</strong> column.</p>