cumulative totals in a workbook
I have a 12mth workbook. The first Sheet is the summary page, followed by an
individual sheet for each month. Monthly data is inputted into the appropriate month and I want the summary sheet to automatically update the figures. I currently manually add up each monthly figure to obtain a cumulative figure. Program is Excel 2000 |
cumulative totals in a workbook
This what I would do, insert 2 dummy sheets, one after the summary sheet but
before the monthly sheets you add, the another dummy last, let's call them First and Last, now when you add a sheet insert it in-between these sheets and since they are empty they won't affect the totals =SUM(First:Last!A1:A25) will sum A1:A25 in all sheets from First to Last and if you put in a March 2006 sheet in there it will also be included, all sheets that you put in-between these 2 sheets will be totaled -- Regards, Peo Sjoblom Portland, Oregon "YvonneAsthma" wrote in message ... I have a 12mth workbook. The first Sheet is the summary page, followed by an individual sheet for each month. Monthly data is inputted into the appropriate month and I want the summary sheet to automatically update the figures. I currently manually add up each monthly figure to obtain a cumulative figure. Program is Excel 2000 |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com