title: How can I perform functions on a specified subset of rows?
body: <p>I want to find the max (min, average, etc.) of a column but only for the subset of rows where another column matches a certain pattern.</p>
  
  <p>For example, here is the data in the sheet named "data":</p>
  
  <pre><code>Date   Value
  Jan    15
  Jan    17
  Jan    3
  Feb    19
  Feb    34
  Feb    37
  </code></pre>
  
  <p>Then in a separate sheet, "reports", I'd like to have:</p>
  
  <pre><code>       Jan    Feb
  Max    17     37
  Min    3      19
  </code></pre>
  
  <p>What function I can put in the cells in the "reports" sheet to get those values?</p>
  
  <p>If it matters, I'm using Gnumeric 1.10.</p>