Thread: running totals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default running totals



"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