title: count all rows in excel that contain some string subset
body: <p>not even sure if this is possible in excel . </p>
  
  <p>i want to compare all the rows in the column and get the count of them if the string contains "the" </p>
  
  <p>so i know i can do this
      =count(B0:B99)   </p>
  
  <p>is there a way to do B0- BN ? the count</p>
  
  <pre><code>  (~df.col3.str.contains('u|z')).sum()  found this trying to make this work so i know its possible now. 
  </code></pre>
  
  <p>now can i only count them if b0- bn contain the string "the" . lets assume all the rows contain strings</p>
  
  <p>my backup plan is exporting the data and writing a ruby script to do it but i feel like i should be </p>
  
  <p>note everything is in column B</p>