Cumulative Total

**laura1812** · 02-23-2014, 11:18 AM

sample.xlsx

Hi

I am looking for help with a formula, I am looking to have column with running total at any one point as apposed to the collective total ie so I can look at certain date and see how much was due at that point. There is column with all the invoices submitted and column with all the payments made. excel.jpg
However need to take into consideration that the invoices are submitted every week so needs to be running total of these minus the running total of the amount paid. Not sure if that is making any sense! Any help appreciated

**BadlySpelledBuoy** · 02-23-2014, 12:18 PM

Hi Laura,

This is a nice easy one to answer, but in keeping with the forum rules you will have to change the title of your thread to something more descriptive of the issue at hand.

Perhaps "Cumulative Totals".

If you change the title we will be able to provide you with your solution.

BSB.

**BadlySpelledBuoy** · 02-23-2014, 12:19 PM

Also, if you could provide a sample workbook rather than the attached picture, you will get your solution even quicker!

**laura1812** · 02-23-2014, 05:58 PM

Thanks for the reply, I have tried to edit the title but I cannot figure out how to do this, I can edit text but not title. Should I just delete and re-post it. Also how do I add sample workbook. Sorry new to Forum and not up to scratch on how things are done. Thanks for your help

**BadlySpelledBuoy** · 02-23-2014, 06:03 PM

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title.

You will also find a button below the post you're editing called "Manage Attachments". Click this then it should be self explanatory to attach the file.