I am using the following function:
=AVERAGEIFS(DataFilledReport!$F:$F,DataFilledReport!$G:$G,'Recruiter Stats'!N$4)
When the recruiter's name is not available in the raw data, it returns #DIV/0!. I am unsure of what to include in the function to eliminate the Div/0 and still return an accurate number. Can anyone assist me on what to add to eliminate this?
Thank you in advance.
Bookmarks