ExcelBanter - running totals

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - running totals (https://www.excelbanter.com/excel-worksheet-functions/192092-running-totals.html)

dcooper

running totals

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?

Billy Liddel

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

All times are GMT +1. The time now is 10:18 PM.