• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

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
0
garyrobbins
Asked:
garyrobbins
  • 2
1 Solution
 
StephenJRCommented:
Does this work?

=COUNTIF(INDIRECT("'"&$E$4&"'!$D$5:$AC$100"),$B6)

You need the quote marks I think.
0
 
garyrobbinsAuthor Commented:
StephenJR:
That did it!
Thanks for the prompt response.

Gary
0
 
garyrobbinsAuthor Commented:
StephenJR:
That did it!
Thanks for the prompt response.

Gary
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now