garyrobbins
asked on
How do I modify my Count IF formula to return BLANK when referenced worksheet is missing?
Ok, This formula did the job nicely (see attached).
[=COUNTIF(INDIRECT("'"&E$4 &"'!$D$5:$ AC$100"),$ B6)
I now want to modify this formula to return a BLANK (or "") when referenced wksht is missing, instead of #REF!.
Any suggestions?
Gary
LCS-by-Activity-Code-08-2011-EE-.xls
[=COUNTIF(INDIRECT("'"&E$4
I now want to modify this formula to return a BLANK (or "") when referenced wksht is missing, instead of #REF!.
Any suggestions?
Gary
LCS-by-Activity-Code-08-2011-EE-.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Barry, thanks for describing yet another way of addressing the issue -- that may be good for a future application where my formula is long and complicated.
I've split the points - hope you find this fair.
Thanks, again for the prompt response. You make my job easier knowing you experts are there to help.
Gary