title: Sum a range that does not contain specific word
body: <p>I would like to sum a range where a corresponding range does not contain "2nd".</p>
  
  <p>Here is the opposite of what I want: </p>
  
  <pre><code>=sum(filter(fUsers,regexmatch(fLabel,"2nd")))
  </code></pre>
  
  <p>Which runs and returns 1,150.</p>
  
  <p>I have looked at and tried to copy these SO posts:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/977251/regular-expressions-and-negating-a-whole-character-group">Regular Expressions and negating a whole character group</a></li>
  <li><a href="https://stackoverflow.com/questions/1240275/how-to-negate-specific-word-in-regex">How to negate specific word in regex?</a></li>
  <li><a href="https://stackoverflow.com/questions/10254774/java-regex-that-matches-anything-but-literal-string-nil-or-nil">Java RegEx that matches anything BUT literal string 'NIL' or 'nil'</a></li>
  </ul>
  
  <p>I know that if I go to the data set in question and use filtering, I should have 15,017 returned. </p>
  
  <p>Based on these posts here is what I have tried:</p>
  
  <pre><code>=sum(filter(fUsers,regexmatch(fLabel,"^(?!2nd$).*")))  // returns #N/A no matches found in filter evaluation.
  
  =sum(filter(fUsers,regexmatch(fLabel,"^(?!.*2nd).*$")))  // returns #N/A no matches found in filter evaluation.
  </code></pre>
  
  <p>How can I get Gsheets to sum values in range fUsers where fLabel does not contain "2nd"?</p>