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