Hi
I have a countif statement below that uses a defined name, but what i also need this formula to do is if there isn't anything in the defined name range then return the word NONE, rather than the #REF! that it currently returns.
=COUNTIF(OutstandingDocs1_Ang.xls!LH_Type,7)
Thanks
#REF error is not related to not finding results per se - it is because the reference (link) is invalid.
Presumably your named range in another file - is the target file open ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks