title: Excel formula for counting the number of incidents of a word in a column?
body: <p>Is there a quicker way of searching for terms without typing each one into the formula? Like, say I have a column that has a bunch of names of locations and I want to find out how many times each one comes up.</p>
  
  <p>This is the formula for when I type in the locations: </p>
  
  <pre><code>=COUNTIF($F$2:$F$274,"*AD library*")
  </code></pre>
  
  <p>I just modify the AD library to the next one, say monastery so it would be </p>
  
  <pre><code>=COUNTIF($F$2:$F$274,"*monastery*")
  </code></pre>
  
  <p>Is there another way of getting the same info without having to type in each one (it's a big sheet with a lot of locations).</p>
  
  <p>Thanks</p>