For example, take a look at the formula in cell C4.Ħ. For example, take a look at the formula in cell C3.ĥ. Select cell C2, click on the lower right corner of cell C2 and drag it down to cell C7.Įxplanation: when we drag the formula down, the absolute reference ($B$2) stays the same, while the relative reference (B2) changes to B3, B4, B5, etc.Ĥ. The second cell (B2) in the range reference is a normal relative reference.ģ.
We fixed the reference to cell B2 by adding a $ symbol in front of the column letter and row number.
Select cell C2 and enter the SUM function shown below.Įxplanation: the first cell ($B$2) in the range reference is an absolute reference.
0 kommentar(er)
