title: Excel averageifs with or function
body: <p>I am using the averageifs function, and have one column where I need to calculate the average if either of the criteria are true.</p>
  
  <p>I have tried using the OR function, and tried the curly brackets, but both give me errors.</p>
  
  <blockquote>
    <p>=AVERAGEIFS(N1:N612,I1:I612,{"FL","IF"})</p>
  </blockquote>
  
  <p>There are more ranges, but the coding for those is fine.</p>
  
  <p>To be clear, I want to return an average if column "I" contains (specifically) the letters FL, <strong>OR</strong> the letters IF. Any other letters should mean that entry is not averaged.</p>
  
  <p>TIA!</p>