Creating 'Advanced' averages

[Saffire]

I don't know exactly how to explain what I am trying to do, so please bear with me.

I have a workbook with 365 pages (one page for each day of the year). On each page (day) I have columns that track the number of people present each hour in various areas of our business. I have been instructed to create a second workbook that summarizes the data by week and then by month.

I guess what I am asking is if there is a formula to make this happen automatically, after I update the daily attendance sheet in the original workbook.

 

[cyrilbrd]

Hi,

if your data would have been in one sheet, you could have used pivot table.