How can I replace a value??

[Skip]

in a column the following formula
Sum(R6:R7)
Sum (R7:R8)
Sum (R8:R9)

goes to
Sum(R19:R20)

I need to replace the first R value with R6
all the way down.
Is there an easy way to do this, other
than changing each formula individually?
Any help apprecited Skip

 

[Niek Otten]

In the top cell:
=SUM(R$6:R7)

fill down

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| in a column the following formula
| Sum(R6:R7)
| Sum (R7:R8)
| Sum (R8:R9)
|
| goes to
| Sum(R19:R20)
|
| I need to replace the first R value with R6
| all the way down.
| Is there an easy way to do this, other
| than changing each formula individually?
| Any help apprecited Skip
|

 

[Dave Peterson]

=sum(R$6:r7)
and drag down.

the $ in front of the 6 means not to change that portion if you copy the formula
elsewhere.

 

[Sandy Mann]

Replace the first formula with:

=SUM($R$6:R7)

and then copy down using the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Earl Kiosterud]

Skip,

Make the first one =SUM(R$6:R7), then copy down with the Fill Handle.