Please Register to Remove these Ads
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