title: excel averageifs with date and greater than criteria
body: <p>I am trying to use the averageifs function in excel to find the average that meets a date criteria and is below three standard deviations. 
  This is what I have</p>
  
  <pre><code>=averageifs(R16:R38375,R16:R38375,"&lt;U19",P16:P38375,U16)
  </code></pre>
  
  <p>The P column contains the date range and U19 is the date criteria. </p>
  
  <p>I have also tried array functions with no luck. Thank you in advance for the help. </p>