title: Google Spreadsheet multiple column filter condition grouping syntax
body: <p>This question is somewhat similar to </p>
  
  <p><a href="https://stackoverflow.com/questions/2512782/google-spreadsheet-multiple-column-filter-using-or">Google Spreadsheet multiple column filter using OR</a></p>
  
  <p>but where as he asks for the equivalent of:</p>
  
  <pre><code>select count(*) 
  from Table 
  where A is not null and (B is not null or C is not null)
  </code></pre>
  
  <p>I would like to do:</p>
  
  <pre><code>select count(*) 
  from Table 
  where A is not null OR (B is not null AND C is not null)
  </code></pre>
  
  <p>In fact what I am trying to do is filter on a date and I have been using </p>
  
  <pre><code>=FILTER(YEAR(Hours!A2:A)=2012,MONTH(Hours!A2:A)&gt;=8)
  </code></pre>
  
  <p>to give me August going forward.</p>
  
  <p>but now I need to add a limit to a certain day for the month. I would need something like this:</p>
  
  <p>=FILTER(MONTH(Hours!A2:A)=8, <strong>(</strong> MONTH(Hours!A2:A)=9 <strong>AND</strong> DAY(Hours!A2:A)&lt;=13) <strong>)</strong></p>
  
  <p>in order to have <strong>all of</strong> August and then September <strong>only</strong> up to the 13th.</p>
  
  <p>Is there a Syntax that allows this?</p>