Solved

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

Posted on 2011-09-06
2
254 Views
Last Modified: 2012-05-12
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
Comment
Question by:garyrobbins
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 36489716
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
 

Author Closing Comment

by:garyrobbins
ID: 36491279
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question