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.
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"?