running totals

D

DCOOPER

I have a column set up for running totals in a invoice tracking sheet. How
do I keep the cells that have the formula copied into them to not show the
last running total?
 
B

Billy Liddel

DCOOPER said:
I have a column set up for running totals in a invoice tracking sheet. How
do I keep the cells that have the formula copied into them to not show the
last running total?
Click to expand...

Say that the invoice amount is in column C and the running total is in
column D,
then in D2 put:

=If(C2="","",sum($D$2:D2))

and copy down.

Peter
 
Top