INDIRECT and arithmetic

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?


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 :heavy_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