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*"),"-")
=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*"),"-")