dragging a formula down a column
I need to get the same range of values as I drag a formula down. For example
in cell A1 I might have the formula =sum(D1:D3). When I drag the formula in
cell A1 down to A2 I want the range to change to (D4:D7) not (D2:D5). I
believe I need to use the offset function but I am confused by it. Please
help.
|