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?

"DCOOPER" wrote:

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?

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