jacksparrow22
New Member
- Joined
- Dec 19, 2011
- Messages
- 9
Hi Guys,
So I have the following formula:
=COUNTIF('Company Actual (NO BEAM)'!$D$7:$D$85,">"&E58)+1
As you can see this formula is referencing another workbook, the issue that I have is that I want to make the $D$7:$D$85 dynamic. I managed to create the following formula:
=INDEX('Company Actual (NO BEAM)'!$M$1451:$BX$1451,MATCH(Summary!E$55&Summary!C71,'Company Actual (NO BEAM)'!$M$5:$BX$5,FALSE))&":"&INDEX('Company Actual (NO BEAM)'!$M$1450:$BX$1450,MATCH(Summary!E$55&Summary!C71,'Company Actual (NO BEAM)'!$M$5:$BX$5,FALSE))
Which throws the range that I am looking for. My question to you is how do I integrate this formula to the one above? I believe you have to create an indirect formula?
Appreciate your help! would save me a late night in the office!
So I have the following formula:
=COUNTIF('Company Actual (NO BEAM)'!$D$7:$D$85,">"&E58)+1
As you can see this formula is referencing another workbook, the issue that I have is that I want to make the $D$7:$D$85 dynamic. I managed to create the following formula:
=INDEX('Company Actual (NO BEAM)'!$M$1451:$BX$1451,MATCH(Summary!E$55&Summary!C71,'Company Actual (NO BEAM)'!$M$5:$BX$5,FALSE))&":"&INDEX('Company Actual (NO BEAM)'!$M$1450:$BX$1450,MATCH(Summary!E$55&Summary!C71,'Company Actual (NO BEAM)'!$M$5:$BX$5,FALSE))
Which throws the range that I am looking for. My question to you is how do I integrate this formula to the one above? I believe you have to create an indirect formula?
Appreciate your help! would save me a late night in the office!
