title: How to check if a criterion is present in a range of cells in Google Sheets?
body: <p>I am trying to collect time information on a maintenance worksheet for work that was completed outside of the current work week.</p>
  
  <p>Right now I am referencing each date cell individually and it works but it's a massive and clunky formula. I've tried out a number of things I haven't used before but none of them seem right. <code>COUNTIF</code> will not work because I need to sum the range based on the value in question not being present in the current range of dates.</p>
  
  <pre><code>=SUM(SUMIFS(WT!$O$4:$O$100,WT!$C$4:$C$100,CONCATENATE("&lt;&gt;",$B$9),WT!$C$4:$C$100,CONCATENATE("&lt;&gt;",$B$10),WT!$C$4:$C$100,CONCATENATE("&lt;&gt;",$B$11)...
  </code></pre>
  
  <p>As I said, the output is correct but I want it to be more easily transferable and scale-able in the case of adding another worker.</p>