Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Totals | Excel Discussion (Misc queries) | |||
Running Totals | Excel Discussion (Misc queries) | |||
running totals | Excel Discussion (Misc queries) | |||
Running Totals | Excel Worksheet Functions | |||
Running Totals | New Users to Excel |