Indirect seems to work for group function “:” =SUM(INDIRECT(“F4:” & “D” & L2))
When I try to use other functions it gives a #REF! error: =SUM(INDIRECT(“F4+” & “D” & L2))
Is there a workaround?
INDIRECT returns reference (i.e., it returns range of cells). What range do you expect from an expression like “F4+D6”?
I see. Is there some other way to perform this intent, use the value in a cell as a row value in an arithmetic expression?
=F4+INDIRECT(“D”&L2)
Perfect, the light comes on.
Don’t see a button to mark this answered, give credit. Am I missing it or is that not on me?
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. That will help other people with the same question.
INDIRECT returns a reference to a range of cells, it is not a way to write arbitrary formulas in textual form.
To add a fixed cell to a cell with address taken indirectly, use
=F4+INDIRECT("D"&L2)