title: Averageifs with OR criteria
body: <p>Trying to run an AVERAGEIFS function across a date variable AND either criteria 1 OR criteria 2 out of a second range. Concept is below. I've found SUMPRODUCT or array formulas to solve the OR problem, but I'm not sure how to combine the date to those solutions. Thanks!</p>
  <p>=+IFERROR(AVERAGEIFS(AVERAGE RANGE,CRITERIA RANGE,(Criteria 1 OR Criteria 2),DATE RANGE,DATE)&quot;&quot;)</p>