How can I replace a value??

's Computer Specifications

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

's Computer Specifications

's Computer Specifications

=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.

Skip wrote:
>
> 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

's Computer Specifications

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 Removed)
(E-Mail Removed) with @tiscali.co.uk

"Skip" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

Skip,

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

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Skip" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I replace color of selected text using the replace feature	bb	Microsoft Word Document Management	5	17th Jun 2008 05:19 AM
String.Replace method not usable when knowing index to replace	Lonifasiko	Microsoft C# .NET	10	17th Oct 2007 09:02 PM
find and replace - replace data in rows to separated by commas	=?Utf-8?B?bXNka2Vy?=	Microsoft Excel Worksheet Functions	1	15th Apr 2006 01:00 AM
'Replace fonts...' should let me replace font style, size, effect.	=?Utf-8?B?Qm9uZ29CdXNobWFu?=	Microsoft Powerpoint	0	10th Feb 2005 04:35 PM
Replace methode, Replace Function, Stringbuilder replace, Regex Replace, Split	Cor	Microsoft VB .NET	4	1st Mar 2004 02:50 PM