ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cumulative totals (https://www.excelbanter.com/excel-programming/387376-cumulative-totals.html)

mantrid

Cumulative totals
 
Can anyone help
I have a list of numbers with an associated date in two coulmns which are
NOT in date order. I wish to add up the numbers in date order creating a
cumulative total to be recorderd in a third cell on the line of the latest
number added.

looking something like

3/5/2003 4 9
2/2/2002 5 5
7/5/2007 1 21
8/9/2004 9 20
6/7/2003 2 11

I have used VBA and can write functions if this is the best approach
Thanks in advance

Ian




All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com