How to use CountIf with Indirect when referring to another worksheet?
Hello again,
See attached example. I want to use INDIRECT to reference a cell that contains the worksheet name. My formula works if I name the worksheet, e.g. data but not if I name it, e.g. 11-08-01. Am I doing something wrong? What would you suggest?
Gary
LCS-by-Activity-Code-08-2011-EE-.xls
See attached example. I want to use INDIRECT to reference a cell that contains the worksheet name. My formula works if I name the worksheet, e.g. data but not if I name it, e.g. 11-08-01. Am I doing something wrong? What would you suggest?
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.
ASKER
StephenJR:
That did it!
Thanks for the prompt response.
Gary
That did it!
Thanks for the prompt response.
Gary
ASKER
That did it!
Thanks for the prompt response.
Gary