Running Total Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2077743%22%20slang%3D%22en-US%22%3ERunning%20Total%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077743%22%20slang%3D%22en-US%22%3E%3CP%3EOK.%20Hopefully%20I%20can%20explain%20this...%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20daily%20sales%20in%20Column%20A%20which%20get%20added%20each%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20plan%20sales%20numbers%20in%20Column%20D.%20They%20are%20prefilled%20in%20for%20the%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20column%20D%20to%20do%20a%20running%20total%20to%20compare%20to%20the%20data%20in%20column%20A.%20So%2C%20if%20sales%20data%20is%20added%20to%20column%20A%2C%20then%20that%20row%20would%20be%20added%20to%20the%20subtotal%20of%20column%20D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlong%20time%20ago%2C%20an%20excel%20wizard%20friend%20built%20me%20this%20formula%2C%20but%20I%20don't%20have%20the%20file%20anymore.%20I%20have%20the%20basic%20SUMIF%20built%2C%20I%20just%20don't%20know%20how%20to%20tell%20it%20to%20add%20in%20the%20next%20row%20each%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20that%20make%20any%20sense%3F%20Help...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2077743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077768%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20Total%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F935653%22%20target%3D%22_blank%22%3E%40mgosling%3C%2FA%3E%26nbsp%3BWhatever%20formula%20you%20already%20have%2C%20copy%20it%20down%20to%20the%20last%20row%20of%20the%20month.%20If%20the%20daily%20sales%20numbers%20are%20blank%20the%20running%20total%20will%20remain%20constant.%20If%20you%20don't%20want%20to%20show%20a%20running%20total%20for%20a%20day%20that%20has%20no%20sales%20in%20column%20A%2C%20you%20may%20wrap%20the%20formula%20in%20an%20IF%20statement%2C%20like%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(isblank(A1)%2C%22-%22%2C%3CYOUR%20formula%3D%22%22%3E)%3C%2FYOUR%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BDemonstrated%20in%20the%20attached%20file.%20If%20this%20doesn't%20make%20any%20sense%2C%20please%20upload%20a%20copy%20of%20your%20file%2C%20after%20deleting%20any%20confidential%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 column D to do a running total to compare to the data in column A. So, if sales data is added to column A, then that row would be added to the subtotal of column D.

 

Along time ago, an excel wizard friend built me this formula, but I don't have the file anymore. I have the basic SUMIF built, I just don't know how to tell it to add in the next row each time.

 

Does that make any sense? Help...

1 Reply

@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.