Posted to microsoft.public.excel.worksheet.functions

Jason R

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula help for counting,with a column of dates and a column of n	Altstatten	Excel Worksheet Functions	2	December 8th 05 09:32 PM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
column to column conditional formatting won't work, need formula	rrupp	Excel Worksheet Functions	1	August 23rd 05 10:06 PM
Value between 2 dates	AG	Excel Worksheet Functions	11	August 21st 05 05:32 PM
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM

All times are GMT +1. The time now is 06:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us