title: How to count a keyword in a series of text strings within multiple cells in Excel?
body: <p>I've found similar ideas on here by using SEARCH or FIND in Excel, but those seem to be more about finding the location of the keyword, rather than counting how many times it comes up.</p>
  
  <p>I have a CSV of a shot list. Each shot is associated with a sequence, and each shot has a set of "tags" (this is the text string).  Please see below for an example:</p>
  
  <p><a href="https://i.stack.imgur.com/4kXUU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4kXUU.png" alt="enter image description here"></a></p>
  
  <p>There are two main keywords I'd like to keep track of: "dog" and "fox". There are multiple shots per sequence, and my goal is to figure out how many shots per sequence have the "dog" tag and how many have the "fox" tag.  The formula I need would be for the columns highlighted yellow, and I have manually entered the first few entires to give an idea of what number should be there.  Once those are filled in, I can then count the ratio per sequence of which ones are tagged more for "dog" or "fox".</p>
  
  <p>I can't use text-to-columns in Excel to easily break down the text string column, because each one contains a different series of tags (somewhat demonstrated by my sample text).</p>
  
  <p>I've figured out a simple formula to count what I want if the text column only had "dog" or "fox" in it, but I can't figure out how to get Excel to find one word within a text string and count it.</p>
  
  <pre><code>=SUMIFS(D:D,B:B,1,F:F,"dog")
  </code></pre>
  
  <p>1 being the sequence number, and the rest of the columns are referencing my larger data sheet.</p>
  
  <p>Any help would be much appreciated!!</p>
  
  <p>Edit:
  Sheet in text form here (sorry about formatting, cant upload a file from work ATM):</p>
  
  <pre><code>COUNTER      SAMPLE DATA
  Sequence    Total Fox   Total Dog   Total Entries   Ratio Fox   Ratio Dog       Sequence    Shot    Text
  1   2   2   4   0.5 0.5     1   mov_101 The quick brown fox
  2   3   2   5   0.6 0.4     2   mov_102 jumps over the lazy dog
  3           4               3   mov_103 The fox and the hound
  4           2               4   mov_104 fox news
  5           3               5   mov_105 I am a dog
                              1   mov_106 The fox and the hound
                              2   mov_107 jumps over the lazy dog
                              3   mov_108 The fox and the hound
                              4   mov_109 jumps over the lazy dog
                              5   mov_110 I am a dog
                              1   mov_111 jumps over the lazy dog
                              3   mov_112 The fox and the hound
                              5   mov_113 The fox and the hound
                              2   mov_114 jumps over the lazy dog
                              2   mov_115 fox news
                              1   mov_116 I am a dog
                              3   mov_117 I am a dog
                              2   mov_118 The fox and the hound
  </code></pre>