title: Formula to select range by condition in Spreadsheets
body: <p>I'm looking for a formula that summarizes a range of a column, filtered by a condition of another column in same row, e.g. the <code>SUM</code> of column <code>B</code> where value in column <code>A</code> is greater than <code>x</code>.</p>
  
  <p>For example I want to have the sum of column <code>F</code>, where the date in column <code>E</code> of that row is within a week from now.</p>