Trying to replace Offset() with a non volatile formula

I use this formula a lot in my worksheets.
In cell $A$47:

=offset(a47,-1,0)+1

I use it so that if I insert a row above row 47, the formula will reference the inserted row.

My most recent workbook has about 1500 SumIf()s that refer to cell $A$47, making all 1500 volatile. It really slows everything down to recalculate all 1500 SumIf()s all the time.

So I'd like to replace it with a formula that isn't volatile.

I tried

=INDEX($A$1:$A47,ROW()-ROW($A$1))+1

but that creates a circular reference

Can anyone think of a formula that works?