title: Regex for counting occurrences of a string within a single cell in Google Sheets
body: <p>I have a Google Sheet filled with data and cells, and would like to get the number of times a string appears in a particular cell, as well as how many times a string appears in total for a single column. For example, I am trying to count the number of "of" strings in a column as follows:</p>
  
  <pre><code>=COUNTA(FILTER('Data Sheet'!G3:G313, REGEXMATCH('Data Sheet'!G3:G313, "of")))
  </code></pre>
  
  <p>However, this just returns the number of cells with an "of". How do I get the total count of "of" strings.</p>