How can I reference a row that is N rows above the current row? I see in the documentation that there is R[]C[] notation, but if I turn that feature on it converts all my references and some of them need to be absolute. Hope this is making sense.

Thanks

When you turn on R1C1 reference style, any cells that are already set to absolute $B$4 will convert to R4C2. Cells that are not absolute B4
will convert to R[-1]C[-2] The lack of [] makes it an absolute reference.

Thanks. I didn't get that when I looked at them.