Thread
:
dragging a formula down a column
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Biff
Posts: n/a
dragging a formula down a column
Hi!
Try this:
=SUM(OFFSET(D$1,(ROWS($1:1)-1)*3,,3))
The results will be:
A1 = SUM(D1:D3)
A2 = SUM(D4:D6)
A3 = SUM(D7:D9)
etc
Biff
"Jason R" <Jason
wrote in message
...
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.
Reply With Quote