title: Google Sheets: how to SUM multiple criteria (AND of OR) where the OR comparisons are strings?
body: <p>For example in <a href="https://docs.google.com/spreadsheets/d/179oMZ1h8cHC9T2yKotsmV9hdpDMIzLM9EOPW-vpobkg/edit#gid=2085573974" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/179oMZ1h8cHC9T2yKotsmV9hdpDMIzLM9EOPW-vpobkg/edit#gid=2085573974</a></p>
  
  <p>I want the sum of <code>Hours</code> where <code>Status</code> = <code>TODO</code> or <code>INPROGRESS</code> <strong>and</strong> <code>Location</code> = <code>NYC</code> or <code>LA</code></p>
  
  <p>Hope I phrased the question clearly enough and thanks for any ideas!</p>