Help with running total/cumulative total for a column

[spez12345]

Hello
I need help/suggestions on how to create a running total without a helper column (running total column). Can this be done in the same column?
Ive attached a screenshot of what i mean.
In the column titles 'tours' am i able to enter a function in the week to date and month to date that would change based on what i enter in the today cell and keep a running tally?

Any help would be greatly appreciated.

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

[spez12345]

Thank you for that. Done.

[Glenn Kennedy]

What do you expect to see? Where do you expect to see it?

[spez12345]

My goal would be to have cells B3 (week to date tours) and B4 (month to date tours) to change and keep a running tally with the number of 'today tours' entered in cell B2. I would also like the week to date and the month to date to reset at the start of a new week/month. I imagine that same function could be used for gross leases, cancels, denials ect.

Can this be accomplished?

[Glenn Kennedy]

So... every day, the values in row 2 will change. You want Excel to be able to remember those values after you overwrite them and provide weekly/monthly summaries. It can NOT do that.

What you CAN do is record all the visits and dates on another sheet (I couldn't put it on an empty sheet as (annoyingly) you seem to have applied protection to your sheet. You cna then use simple formulae to pull today's data (done) and summary data (not yet done) across.

If this approach is OK, I'll finish the job. If not, you'll need to have a rethink!

If it's OK... does your week run Mon-Sun or what?

[spez12345]

How about this.. can the totals remain and keep a tally in B3 and B4 and then i can manually reset them to zero once a new week/month happens? So i would be adding tours from the day in B2 to B3 and B4 daily.
I have included a nonprotected excel sheet.
So essentially 11 tours would stay in B3 and B4 until the following day. If i had 5 tours entered in B2, that 5 would increase B3 and B4 to 16.
Can this happen?

[kvsrinivasamurthy]

Worksheet event is used . When you enter a number in B2 automatically B3 and B4 will be incremented By B2 value.
Code

Please Login or Register  to view this content.

How to use workheet event the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm

[spez12345]

Hello
thank you for that. One problem arose. when i reset the value to a different number in b3 the auto tally stopped working.

[kvsrinivasamurthy]

Can you explain in more detail with example.

[spez12345]

The tally works perfectly but currently there is no way to reset the values in B3 and B4 to zero. If a new week or month starts and i manually enter "0" in those cells, the tally stops working. i included the current worksheet as an attachment.

[kvsrinivasamurthy]

Where is the file. For that sheet have you included the worksheet event.