what I'm trying to do is- I've a column in my excel workbook called "Banked Amount" which varies from month to month. Now, what I would like to do is to calculate a total of all the "Banked Amount" cells. Is there a formula that can do this automatically every month by picking up values from all previous month's banked amounts and putting a total on top of my workbook.
Note: As the year progresses, newer "banked amounts" cells are added to the workbook.