Replace #DIV/0! with "0" in Averageifs function results

Hello.

I am using the AVERAGEIFS function to average multiple percentages in a column by rep. I have tried to embed the IFERROR funnction which in turn gives me a #N/A. Not sure what I am doing wrong. I have attached the spreadsheet for review. Can anyone assist?

Thanks,

B2 and down: =IFERROR(AVERAGEIFS('OA Stack Ranking Detail'!$I:$I, 'OA Stack Ranking Detail'!$C:$C, 'Stk Rank Avgs'!$A2, 'OA Stack Ranking Detail'!$B:$B, B$1), 0)

C2 and down: =IFERROR(AVERAGEIFS('OA Stack Ranking Detail'!$I:$I, 'OA Stack Ranking Detail'!$C:$C, 'Stk Rank Avgs'!$A2, 'OA Stack Ranking Detail'!$B:$B, C$1), 0)

Delete unused rows and columns, and your workbook shrinks 1000:1.

nickelcell,

the Development Testing Forum is for testing, not for asking questions. Please select an appropriate forum before starting a new thread.

Moved to Excel Worksheet Functions.

Sorry for not noticing, T.

My apologie teylyn. I didn't realize i was in the incorrect category. Thank you for letting me know.

Thank you shg the function worked great. I guess there is nothing else I need to do here, correct? Like apply "Solved" or anything?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save