Help with Formula to return running YTD total based on a date range

[RubiksCuber]

I am trying to come up with a formula that does the following:

In the attached worksheet - I would like row 61 (YTD row) return a YTD running total of that columns information based on todays date.

So based on whatever the current date is, I want a YTD today based on the last week ending -

for example - If today was 2/20/2012 - I want D61 to return the sum of D8 through D14
but if the date is 2/27/2012 - i want D61 to return the sum of D8 through D15


any suggestions?

[dangelor]

Using the SUMPRODUCT function...

=SUMPRODUCT((D8:D59)*($B$8:$B$59<=TODAY()))

and copy across.


HTH,
Rich