Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How to use CONCATENATE to fill in variables in a COUNTIF formula?

Hello again, Experts.  I need your help.

See attached worksheet for details.  I'm trying to develop a flexible COUNTIF formula using CONCATENATE to fill in the variables from reference cells.

Is this a klugy approach??  I bet you guys can give me a better solution.

Gary
LCS-by-Activity-Code-08-2011-EE.xls
0
garyrobbins
Asked:
garyrobbins
1 Solution
 
Rory ArchibaldCommented:
You'll need to use INDIRECT as well (passing the result of the CONCATENATE formula) and the source workbook will need to be open.
0
 
garyrobbinsAuthor Commented:
Rorya:  Not the answer I wanted but it is what it is.

Next question will refer to a workaround...

Thanks for the fast response.

Gary
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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