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.
Last edited by nickelcell1; 06-14-2011 at 12:28 AM.
Hi,
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This worked like a charm. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks