In the attached WB, I'm trying to place a formula in RESULTS 1 Q8 that averages DATA Table1 POINTS G/L with 2 criteria... percentage < 20% of PDC to PM MAX GAP, and a SETUP of PMH.
Here's what I tried...
Please Login or Register to view this content.
Last edited by cableghost; 10-05-2021 at 08:27 AM.
Table1[PM MAX GAP] and Table1[PDC] are empty ? Divide by 0 !
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Q8=AVERAGEIFS(Table1[POINTS G/L],Table1[PM MAX GAP],"<20%",Table1[SETUP],$P8)
R8=AVERAGEIFS(Table1[POINTS G/L],Table1[PM MAX GAP],">=20%",Table1[PM MAX GAP],"<50%",Table1[SETUP],$P8)
Yep, I didn't upload WB with all my data. I can simply wrap it in a IFERROR.
Thank you, joseph!
Glad to be of help. Thanks for the Rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks