The cell reference of the above formula =SUM(B4:B7) when dragged across to column C adjusts itself to then sum the results of C4 to C7.
For Example if the position of the cell that contains the formula changes, the reference is changed. These are basic cell references that adjust and change when copied or using the Auto fill function in Excel. Just what is the difference between an absolute and a relative cell reference in Excel?.Ī relative cell reference is the most widely used cell reference in formulas in Excel.
0 kommentar(er)
