Excel - AVERAGEIFS with OR conditions

0 votes

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

what I'm working with

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 in Database by Edureka
• 9,700 points
18 views

1 answer to this question.

0 votes

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.

Excel AVERAGEIFS function

answered Mar 31 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

how do I calculate discount with if function in excel?

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

answered Feb 23 in Database by Edureka
• 8,820 points
198 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

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

answered Mar 14 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

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

answered Mar 15 in Database by Edureka
• 8,820 points
56 views
0 votes
1 answer

Sigma or Summation function in Excel

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

answered Mar 15 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer

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

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

answered Mar 15 in Database by Edureka
• 8,820 points
45 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
27 views
0 votes
1 answer

Excel: Highlighting duplicates with exact matches

To enter the Advanced Filter dialogue box, ...READ MORE

answered Mar 24 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP