title: Excel - AVERAGEIFS with OR conditions?
body: <p>I'm trying to calculate a percentage value which uses an AVERAGEIFS function. Not quite sure how to describe it without context, so here's what I'm working with (minus 100+ rows of data):</p>
  
  <p><img src="https://i.stack.imgur.com/T2dD2.png" alt="what I&#39;m working with"></p>
  
  <p>I've made the function look in column D for values of "W" and column C for values of "Cache" (<code>=AVERAGEIFS(L6:L205,D6:D205,"W",C6:C205,"Cache"</code>). I was hoping there was a way to make this function look for values of "W" or "R" in column D, instead of just "W".</p>
  
  <p>I tried writing: <code>=AVERAGEIFS(L6:L205,D6:D205,"W",C6:C205,"Cache")+AVERAGEIFS(L6:L205,D6:D205,"R",C6:C205,"Cache")</code>
  But this just added the two percentages together, instead of considering boths rows which contain "W", or "R".</p>
  
  <p>I also tried adding OR between the functions (instead of the +) with a variety of bracket combinations, but excel wasn't a fan of that.</p>
  
  <p>If anyone has any suggestions or solutions to this I'd be grateful! </p>