Need formula for cumulative total

[anandakuttan]

I want a dynamic cumulative sales sheet. when i enter a particular day sales, it should be added to the month to date sales. when the next day sales is entered by overwriting
first cell the cumulative total get wrong as the previous day sales in not taken Please see attached excel and help to solve this issue.

[Logit]

.
In D3 enter

Please Login or Register  to view this content.

Click on D3, click and hold on small dot lower right hand corner, drag down to D6.

Click on EXCEL BUTTON, upper left hand corner.

Click on EXCEL OPTIONS

Click on FORMULAS

Click on ENABLE ITERATIVE CALCULATION / MAXIMUM ITERATIONS = 1

Click OK.


Enabling ITERATIVE CALCULATION / MAXIMUM ITERATIONS=1 has the effect of overwriting the "Circular Reference" error, and allows
the updating/adding of numbers in the same cell as the formula.

[anandakuttan]

Thx for the reply. I tried but it didnt work. may be i am not sure how to do. Can you help to add this in my attached file and send back. thanks a million

[AliGW]

If you want t total that will update each time you add fresh figures to the table (adding them to what was there before), you will need VBA code. Please confirm.

[anandakuttan]

I wont be adding to the C3. I will overwrite the C3 with next days sales. As such D3 will add only C3 with today's sales. yesterday's sales wont be added as i overwrite them with today's sales.
IF VBA can help i am ok with it.

[Logit]

.
See attached

And Ali is correct - using VBA is ANOTHER means of obtaining your goal but you asked for a formula?

[anandakuttan]

Dear Logit.

Thanks a lot for your help. It works exactly the way i wanted. please explain me how did you do that.

Rgds,
Ram

[Logit]

.
Follow steps in Post #2 while referring to the images below :

ExcelButton.jpg

ExcelOptions.jpg

terations.jpg

[anandakuttan]

Dear Friends,

I need a Dash Board as per attached sheet. The Actual and Budget data are in 2 separate sheets.
I want the dash board to populate when i choose the store name from the drop down menu in the Dash board.
Ignore the cells marked with RED where i will manually put the total and formula

Thanking in advance
Anand

[AliGW]

Start a new thread for this different request, please.