One way to set it up ..

Assuming the layout below
is typical for each of the 12 monthly sheets
in AN10:AO40 whe
AN10:AN40 contains actual dates, and
AO10:AO40 contains hours worked values

01-Jan-04 10
02-Jan-04 10
03-Jan-04 10
04-Jan-04 10
etc

and the 12 monthly sheets are named simply as: 1, 2, 3 ... 12

Then you could try setting up in a new sheet: Summary
the table below:

DaysPast 1 2 3 ... 12
365
90
30

where B1:M1 contains the 12 sheetnames: 1,2,3, ... 12
and in A2 down is listed the desired "last" x days: 365, 90, 30 ..

To populate the table,

Put in B2:

=SUMPRODUCT((INDIRECT("'"&B$1&"'!$AN$10:$AN$40")= TODAY()-$A2)*(INDIRECT("'"&B$1&"'!$AN$10:$AN$40")<TODAY()) ,'1'!$AO$10:$AO$40)

Copy across to M2, fill down to A4

The above will return the required summations
from the range AO10:AO40
in each of the 12 monthly sheets
where the dates in AN10:AN40
fall within the last x days as specified in col A

To complete the table, you could just have a "Total" in N1,
put in N2: =SUM(B2:M2)
copy down to N4

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Wayne" wrote:

I would like to display daily data, accumulated from a 12 month calendar on a
SUMMARY sheet at the end.
This data is hours worked in the "last" 30 days, 90 days and 365 days,
stored in cells AN10:AP40 for each month.
Looking for direction ...
Thanks

Wayne McK.