Copu Formula HELP PLEASE !!

Gfr · Mar 30th, 2004, 07:40 AM

i've one question about copy a formula:
In cel D14 i've got this formula: "=Sum(A1:A5), now i copy (with mouse)this form to D15, and in D15 the formula is "=Sum(A2:A6) and i want this formula =Sum(B1:B5) is it possible??

Thanks,
Gfr

fairwinds · Mar 30th, 2004, 08:01 AM

Hi,

You could try changing the formula in D14 to

=SUM(OFFSET($A$1,0,ROW()-14,5))

Aladin Akyurek · Mar 30th, 2004, 08:19 AM

Quote:

Originally Posted by fairwinds

...

You could try changing the formula in D14 to

=SUM(OFFSET($A$1,0,ROW()-14,5))

Yep, but...

=SUM(OFFSET($A$1,0,ROW()-ROW($D$14),5))

Mar 30th, 2004, 07:40 AM	#1
Gfr Join Date: Mar 2004 Posts: 2	Copu Formula HELP PLEASE !! i've one question about copy a formula: In cel D14 i've got this formula: "=Sum(A1:A5), now i copy (with mouse)this form to D15, and in D15 the formula is "=Sum(A2:A6) and i want this formula =Sum(B1:B5) is it possible?? Thanks, Gfr

Mar 30th, 2004, 08:01 AM	#2
fairwinds MrExcel MVP Join Date: May 2003 Posts: 8,445	Re: Copu Formula HELP PLEASE !! Hi, You could try changing the formula in D14 to =SUM(OFFSET($A$1,0,ROW()-14,5)) __________________ "Fair Winds and Following Seas"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode