Why does my header formula change as I add rows? I don't want it to change.
My header needs to display a number, which is calculated as follows: B2-B3.
Whenever I add a row, the header formula automatically changes to B3-B4. I don't want that to happen. I need the formula to remain as B2-B3 as I add rows.
I tried using $B$2 and $B$3 instead, but that didn't help. The formula still changed.
This is the original formula when I had two rows:
As I added a third row above, the formula changed:
How can I prevent it from changing?
Thank you in advance.
MacBook Pro 16″