Ok,
So strange question. I have a series of dynamic ranges that will change based on the user input. I have a formula that matches the various criteria and concatenate the variable range. For example, it will return "$F$20:$F$34" in cell O9. I then have another formula " =COUNTIF($F$20:$F$34, ">" & R$7) that returns the count based on my request. However, I want the cell range to change based on what appears in cell O9 since that data will change. If I use =COUNTIF(O9, ">" & R$7) it obviously does not work because it does not reference the actual range, but rather the text in O9. Is there any way to do this?
Thank you!
Bookmarks