Relative cell reference problem

Completely new to Excel formulas. I'm using Excel 2010 on Windows 10 64-bit. I am trying to do a simple add and subtract operation using a formula, but when I copy and paste the formula, it does no...

Formulas and Functions

Riny_van_Eekelen
May 16, 2021
rwadleigh Your understanding of the workings of the $ is correct. When you drag or copy/paste a cell downwards, the row references should update automatically. You are not, by any chance copying from the formula bar? Because then the updating does not happen.

Since you mentioned to be completely new to Excel formulas, allow me to comment on the formula in question. You don't need the SUM function and it isn't really very meaningful. -$E3+$E3 = zero and can thus be omitted. You may use =$G2 to achieve the same outcome.

Riny_van_Eekelen

Platinum Contributor

May 16, 2021

rwadleigh Your understanding of the workings of the $ is correct. When you drag or copy/paste a cell downwards, the row references should update automatically. You are not, by any chance copying from the formula bar? Because then the updating does not happen.

Since you mentioned to be completely new to Excel formulas, allow me to comment on the formula in question. You don't need the SUM function and it isn't really very meaningful. -$E3+$E3 = zero and can thus be omitted. You may use =$G2 to achieve the same outcome.

rwadleigh

Copper Contributor

May 16, 2021

I continue to be careless in my edits. Formula should be $G2-$E3+$F3.

Forum Discussion

Relative cell reference problem

Resources