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
garyrobbinsAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.