title: How do I count matches in Excel using an array of criteria?
body: <p>I've got a spreadsheet with several columns of data. Let's say they're names of animals. I also have a collection of terms I'd like to find in the data, and those terms are arranged in columns of related terms. So, for this example, a column of "Pets", with the terms "dog", "cat", "fish", each term appearing in a separate cell. Another set of terms could be "Food", with the terms "fish", "chicken", "turkey", etc.</p>
  
  <p>Is there a way to cite an entire column of those terms--e.g., $E$2:$E$10--as the search criteria? I know there are ways to include multiple search criteria within combinations of SUM, SUMIFS, SUMPRODUCT, COUNT, COUNTIFS, COUNTA, MATCH, etc., but everything I've found so far would require me to name each term within an array formula.  </p>