Dynamically create a formula from a field that contains the formula in text form

[AngelCity]

Hello,

I am trying to dynamically create a formula in excel.

Background:
I have created a spreadsheet that users will be populating on an ongoing basis with assessments they are making on a daily basis. To dynamically support users creating a weighted score from their daily assessments, I would need to know from what date to what date they want to perform a calculation on. As such, I would like to dynamically create a formula based on users saying, "I want to do calculations from data in row x to data in row y" - something like that.

What I have done:
I have done the below, but I am stuck on how to progress forward. Does anyone have suggestions on how I can accomplish what I am trying to do?

What I have done (i.e. the contents of some cells):

User specifies their 1st & last row:
1st Row: 9
Last Row: 18

I then dynamically create the formula that would use these rows by creating the below text:
Formula: =CONCAT("=COUNTIF(Q",B3, ":Q", B4, ",""Y"")")

=> Note, the formula I created reads as:
=COUNTIF(Q9:Q18, "Y")


Question:
How can I now execute this formula that I have dynamically created by having the user specify from what row to what row they want to count the number of "Y"s they have indicated over a couple of days or months?

Any guidance would be very much appreciated!

 

[Trevor_S]

Try using the INDIRECT function:
=COUNTIF(INDIRECT("Q"&B3&":Q"&B4),"Y")