Max .. Tks for the help. I should have provided better info to start with.
AN10:AP40 contain hours worked
AQ10:AQ40 contain days of the month
AN9 contains 30 days
AO9 contains 90 days
AP9 contains 365 days (12 months)
AQ9 contains days of the month

sheets are noted, Jan, Feb, Mar ... 2005 Summary

Year "2005 Summary" Sheet, has numerous accumulated records for the past yr.
The 30, 90, 365 day column's have a column header =NOW()
k3 contains =Now()
K4 contains 30 days
L4 contains 90 days
M4 contains 365 days

By year, A20 contains the current Year, and row 20 has many year SUM totals.
I would like to indicated the =Now() 30, 90, 365 days hours worked in:
K3 contains =NOW()
K4 30 day
L4 90 day
M4 365 day

K20 ? =NOW() hours worked
L20 ? =NOW() hours worked
M20 ? =NOW() hours worked

It would really make my day to solve this!

Again, Merci, Thanks for the help!

Wayne ... Montreal Canada
"Max" wrote:

Apologies, correction to formula:

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)

should instead be:

Put in B2:

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

(corrected the last part of the formula, forgot the INDIRECT(...) ..)

Note: In the preceding suggestion, the range AP10:AP40 was ignored. If you
also have "hours worked" in that range to be conditionally summed in the same
manner, just make a duplicate of the sheet: Summary, and change the range to
sum to point to "AP10:AP40" instead,

i.e. Put in B2 (in the duplicated sheet):

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

Then fill across and down to populate the table as before

This will return the corresponding results for the range "AP10:AP40"

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