If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
Linear Mode
