Solved

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

Posted on 2011-09-06
2
248 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

705 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now