running totals

  • Thread starter Thread starter DCOOPER
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running total in blank cells 3
Convert currency within column 1
90 day Running total 1
Simple totals 4
Auto Change Formulas - Please Help. 2
excel problem 1
How can I create a running yearly total for all of my invoices? 1
Formula to sum up customers totals from other sheets 2

Back
Top