title: How to check string text with OR logic using COUNTIF function in Google Sheets
body: <p><strong>Goal:</strong>
  If possible I want to simplify the following statement. The functionality is to count data that has a status called &quot;Finished A&quot; &quot;Finished B&quot; or &quot;Finished C.&quot; And the reference for $K$2 is referring to a cell with a particular date.</p>
  <p>For example, if Finished A had 3, Finished B had 2, and Finished C had 4, then the total count would be 9. That's the calculations.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>=COUNTIFS('Data'!$D$4:$D,"Finished A",'Data'!$G$4:$G,"="&amp;$K$2) + 
  COUNTIFS('Data'!$D$4:$D,"Finished B",'Data'!$G$4:$G,"="&amp;$K$2) + 
  COUNTIFS('Data'!$D$4:$D,"Routed C",'Data'!$G$4:$G,"="&amp;$K$2)</code></pre>
  </div>
  </div>
  </p>
  <p><strong>Challenge:</strong>
  This particular example above is quite simple so it's manageable and if I need to make any changes, it's not going to be a problem. However if there are more criteria, then it would gets very long and difficult to read and manage. So if there's a way to shorten the above, it would be great. In the above case, I think there could there a way to combine the different statuses by using the OR logic (ex. |).</p>
  <p>There was a case where I used &quot;|&quot; symbol to make an OR logic when using the Query function, however it didn't work with the Countifs functions.</p>
  <p><strong>Question:</strong>
  Is there a way to do something like the following?</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>=COUNTIFS('Data'!$D$4:$D,"Finished A|Finished B|Finished C",'Data'!$G$4:$G,"="&amp;$K$2)</code></pre>
  </div>
  </div>
  </p>