multi-sheet conditional summing
Posted by Shawn on May 19, 2000 7:38 AM
I have a workbook with a summary sheet which contains:
month, total, %ofbasemonth, %oflastmonth, currentdiff
and 8 (it will grow) sheets after with the following:
Date, startserial, endserial, quantity, running total
On my summary page I need to track the totals for each month, up to the last entry in the current month.
i.e. today is May 19 - currentdiff for each month should = the sum of serials up to the 19th of each month.
I hope I explained this well enough.
Posted by Garry on June 12, 2000 12:31 AM
Good morning Shawn,
I have salesmen with spreadsheets to monitor their individual sales figures on a monthly basis.
The first sheet in my workbook is also a summary sheet, followed by 12 sheets, one for each month.
On the monthly sheet, I have set my total cells at the top of the sheet, thus enabling the salesmen to extend the sheet without affecting the location of the 'Total' cell. The range specified in the total cell has been increased to cater for a more than the expected number of entries. If you don't wish to have the Total cell at the top of the page, you can always 'Name' the cell, then where ever the cell ends up, the referencing cell will be able to find it.
I have to go, now, but I shall continue the answer later.
