Forum Discussion
Running Total Formula Help
OK. Hopefully I can explain this... I have daily sales in Column A which get added each day. I also have plan sales numbers in Column D. They are prefilled in for the month. I would like c...
mgosling Whatever formula you already have, copy it down to the last row of the month. If the daily sales numbers are blank the running total will remain constant. If you don't want to show a running total for a day that has no sales in column A, you may wrap the formula in an IF statement, like:
=IF(isblank(A1),"-",<your formula>)Demonstrated in the attached file. If this doesn't make any sense, please upload a copy of your file, after deleting any confidential information.