Any way to duplicate a formula that needs individual relatively absolute references?

Question

I need to duplicate a formula down for many rows. However each one needs to be an absolute reference, referencing a specific cell in that individual row. I can't just fill down the original formula with an absolute reference, or every row will be identical.

Example formula:

=IF(AND(ISBLANK(D$5),ISBLANK(H$5)),"",IFERROR((SUM(D$5,H$5)), "ERR"))

Desired result after filling down one cell:

=IF(AND(ISBLANK(D$5),ISBLANK(H$5)),"",IFERROR((SUM(D$5,H$5)), "ERR"))
=IF(AND(ISBLANK(D$6),ISBLANK(H$6)),"",IFERROR((SUM(D$6,H$6)), "ERR"))

I need to do this, because I will be inserting (and shifting down by one) cells in columns A, D, and H, every day. Without the absolute references, the formulas above will change to follow where the data has moved, and I need them to always track whatever happens to be in those cells at the moment, but I have hundreds of rows to fill.

Is there any way to replicate a formula like this, hundreds of times down the sheet, while creating such "relative absolute references"?

Answer 1

Here's what I ultimately came up with:

=SUM(indirect("D"&cell("row", I5)),indirect("H"&cell("row", I5)))

There is one catch that I missed for a bit but once I saw it, I realized what I was overlooking.

The cell you're going to use to get the cell("row") from, has to be in a row that is NOT going to move. It doesn't even have to be a cell in use, though I chose one that is. So in my case I used column I.

Now I can insert and shift down in columns D and H, and all my sums off to the right follow my changes. Works great!