Excel - AVERAGEIFS with OR conditions

Question

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):

I've made the function look in column D for values of "W" and column C for values of "Cache" (=AVERAGEIFS(L6:L205,D6:D205,"W",C6:C205,"Cache"). 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".

I tried writing: =AVERAGEIFS(L6:L205,D6:D205,"W",C6:C205,"Cache")+AVERAGEIFS(L6:L205,D6:D205,"R",C6:C205,"Cache") But this just added the two percentages together, instead of considering boths rows which contain "W", or "R".

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.

If anyone has any suggestions or solutions to this I'd be grateful!

Answer 1

The AVERAGEIFS function in Excel determines the average of numbers in a range that satisfy one or more criteria. For partial matching, logical operators (>,,>,=) and wildcards (*,?) can be used in the AVERAGEIFS criterion.