Averageifs with multiple criteria

[RMP1960]

The formula listed below is only averaging items for "5B" and does not include items from "LI". I have tried everything I know to get it to produce the desired results. Any ideas?

=IFERROR(AVERAGEIFS('WORK ORDERS APPROVED DATA'!$N$7:$N$3500,'WORK ORDERS APPROVED DATA'!$G$7:$G$3500,P11,'WORK ORDERS APPROVED DATA'!$J$7:$J$3500,{"5B","LI"},'WORK ORDERS APPROVED DATA'!$L$7:$L$3500,"=70*"),"-")

 

[Fluff]

Hi & welcome to MrExcel
untested, but try
=IFERROR(SUM(AVERAGEIFS('WORK ORDERS APPROVED DATA'!$N$7:$N$3500,'WORK ORDERS APPROVED DATA'!$G$7:$G$3500,P11,'WORK ORDERS APPROVED DATA'!$J$7:$J$3500,{"5B","LI"},'WORK ORDERS APPROVED DATA'!$L$7:$L$3500,"=70*")),"-")

 

[RMP1960]

Thanks! I tried the new formula and it did not work.......

 

[Fluff]

Define "it did not work"

 

[Fluff]

Swap the SUM for AVERAGE

 

[RMP1960]

Swapped the "Sum" for "Average" and the result was "-"

 

[Fluff]

That means that you are getting an error in the formula, I cannot help to find out the problem as I have no idea what your data is like.

 

[RMP1960]

That means that you are getting an error in the formula, I cannot help to find out the problem as I have no idea what your data is like.

Still looking for help with the averageifs formula..........Getting desperate!

 

[Fluff]

Have you tried using "Evaluate formula" on the formula tab?
Failing that can you supply a small sample of your data, there are add-ins available here that enable you to post data to the thread.

 

[RMP1960]

I evaluated the formula and I can see that it is averaging for both "5B" and "LI", but the result is only displaying the average for "5B". Where as I need the formula to average for "5B" and "LI" and show the result.