Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 Bill Posts: n/a
how to auto increment cell location within formula

forgive me if this is basic stuff but I am trying to figure out the
following: have 2 columns of numbers say C and D where I need a running
total starting at say D4 with the formula=SUM(C4-C3) then D5 would be
SUM(C5-C4); then D6 SUM(C6-C5) and so on. Is there a way to automate
this? Thanks - Bill

#2
Posted to microsoft.public.excel.worksheet.functions
 Biff Posts: n/a
how to auto increment cell location within formula

Hi!

Just enter this formula in D4:

=C4-C3

Now, just drag copy down the column and the cell references will
automatically increment.

Biff

"Bill" wrote in message
oups.com...
forgive me if this is basic stuff but I am trying to figure out the
following: have 2 columns of numbers say C and D where I need a running
total starting at say D4 with the formula=SUM(C4-C3) then D5 would be
SUM(C5-C4); then D6 SUM(C6-C5) and so on. Is there a way to automate
this? Thanks - Bill

#3
Posted to microsoft.public.excel.worksheet.functions
 Kevin M Posts: n/a
how to auto increment cell location within formula

Hi Bill, are you referring to Autofill? Once you have a relative cell
reference in (without \$ signs) as in your example, you move your mouse to the
lower right hand corner of that cell and your cursor turns from white cross
hair to a black crosshair, left-click and hold, drag it down as far as you
need it to go.

HTH,
Kevin M

"Bill" wrote:

forgive me if this is basic stuff but I am trying to figure out the
following: have 2 columns of numbers say C and D where I need a running
total starting at say D4 with the formula=SUM(C4-C3) then D5 would be
SUM(C5-C4); then D6 SUM(C6-C5) and so on. Is there a way to automate
this? Thanks - Bill

#4
Posted to microsoft.public.excel.worksheet.functions
 Bill Posts: n/a
how to auto increment cell location within formula

thanks - worked great; I thought I tried this yesterday but apparently
botched it.
Bill
Biff wrote:
Hi!

Just enter this formula in D4:

=C4-C3

Now, just drag copy down the column and the cell references will
automatically increment.

Biff

"Bill" wrote in message
oups.com...
forgive me if this is basic stuff but I am trying to figure out the
following: have 2 columns of numbers say C and D where I need a running
total starting at say D4 with the formula=SUM(C4-C3) then D5 would be
SUM(C5-C4); then D6 SUM(C6-C5) and so on. Is there a way to automate
this? Thanks - Bill

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM dingy101 Excel Discussion (Misc queries) 1 November 21st 05 08:51 AM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM Amanda Excel Worksheet Functions 5 January 5th 05 07:37 AM

All times are GMT +1. The time now is 09:36 PM.

The comments are property of their posters.