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!

Mar 30, 2022 in Database 1,336 views

## 1 answer to this question.

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.

• 23,260 points

## how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

## MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

## How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

## Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

## Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE