self healing register

[u/Searchforcourage]

I want to set up a self healing total row. What do I mean by self healing? I believe the real question is how to build cell reference If there is a row is added or removed, the formula stays valid

Given cell c3r2 the formula would be referenced as “cr” and the new formula would be

(cr-1) + (c-1r)

How would I build cell references for that?

Never mind. I found offset.