software

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 - BillHi!

Just enter this formula in D4:

=C4-C3

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

Biff

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

quot;Billquot; wrote:

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

thanks - worked great; I thought I tried this yesterday but apparently
botched it.
Bill
Biff wrote:
gt; Hi!
gt;
gt; Just enter this formula in D4:
gt;
gt; =C4-C3
gt;
gt; Now, just drag copy down the column and the cell references will
gt; automatically increment.
gt;
gt; Biff
gt;
gt; quot;Billquot; gt; wrote in message
gt; oups.com...
gt; gt; forgive me if this is basic stuff but I am trying to figure out the
gt; gt; following: have 2 columns of numbers say C and D where I need a running
gt; gt; total starting at say D4 with the formula=SUM(C4-C3) then D5 would be
gt; gt; SUM(C5-C4); then D6 SUM(C6-C5) and so on. Is there a way to automate
gt; gt; this? Thanks - Bill
gt; gt;