Is Tyler Nash on the Board who can read my question？

[Smitty]

All that said, I really don't like how the workbook in the example is designed. I prefer to design my workbook solutions more like I design my database solutions: I would use only one worksheet for ALL of my hours logged across all weeks, months, and years. This way I don't have to worry about making new worksheets every period, and analysis (sums, lookups, PivotTables, charting) becomes extremely simple. This is how the pros do it

Can I get an Amen!

 

[Fazza]

You sure can from me, Smitty : AMEN

There are many Mr Excel threads every day where horrible formulas - or what would otherwise be unnecessary VBA - are offered to answer questions that wouldn't even exist if spreadsheets were set up sensibly - that is, set up like a database.

It doesn't help the cause for a good approach when the solution here, entered with CTRL-SHIFT-ENTER, is

=SUM(IFERROR(N(INDIRECT("'"&TEXT(DATE(2015,1,7)+(ROW(1:53)-1)*7,"MMM D")&"'!H1")),0)*IFERROR(N(INDIRECT("'"&TEXT(DATE(2015,1,7)+(ROW(1:53)-1)*7,"MMM D")&"'!A2"))>=A1,0)*IFERROR(N(INDIRECT("'"&TEXT(DATE(2015,1,7)+(ROW(1:53)-1)*7,"MMM D")&"'!A2"))<=A2,0))



@Kevin : thank you very much for commenting that you'd set up like a database.

Regards, Fazza