title: Google Spreadsheet multiple column filter using OR
body: <p>I have a Google Spreadsheet with 3 columns that are either blank or have a value.  I want to get the count of the number of rows that has A and either B or C populated.  If I were writing a SQL query it would be</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>But I can't for the life of me figure out how to get this in a Google Spreadsheet</p>