Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel cumulative totals based

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Cumulative Totals based on Dates

Excel Cumulative Totals based on Dates

ResolvedVersion 2010

Adrian has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel Intermediate course

Excel Cumulative Totals based on Dates

Hi

I am trying to create a cumulative total based on dates, but am having trouble doing so. I have tried a sumif formula, but it doesn't quiite work. Failing my suggestion below, perhaps its possible to have the cumulative total for such today, ie whats the cumulative total right now, rather than seeing the historic totals also

I have a start dates and end dates in format 23/09/2015 06:00:00. I have another column that has values next to it for each date range. I want a 4th column that tracks a running total of these values as dates come and drop off ie:

Start Date End Date Qty Cum Total
01/01/2015 01/03/2015 10 10
01/02/2015 02/02/2015 15 25
02/02/2015 06/02/2015 5 15
03/02/2015 05/02/2015 10 25
05/02/2015 06/02/2015 100 115
06/02/2015 07/02/2015 50 60

Your help would be much appreciated, many thanks

Adrian

RE: Excel Cumulative Totals based on Dates

Hi Adrian,

Thank you for the forum question.

I am not sure I understand the logic in what you want but I have created a workbook where I am using if. Have a look at it and please let me know if this is what you want.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

example.xlsx

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.