Hello,

I am trying to reference a range of cells using indirect references. I need to use the same equation for the entire column. I want the range to shift with the cell it is entered in (which works), but with my current equation the range extends above the first cell in the worksheet it flips to the bottom.

Equation used:
=SUM(INDIRECT("R[-5]C[-1]:RC[-1]",0))

When the equation is placed in B3, the interpreted range is $A$1:$A$1048573, when I would like it to be $A$1:$A$2.

Any suggestions for modifications or alternate approaches would be greatly appreciated.