Your problem is that you did exactl as I said. <g

I goofed up on the range for the times by starting it in row 1 instead of
row 2. Use:

=SUMPRODUCT((Tracking!E2:E120=(TODAY()-WEEKDAY(TODAY(),2))-X)*(Tracking!E2:E120<=(TODAY()-WEEKDAY(TODAY(),2))-Y)*Tracking!D2:D120)

and replace the X and Y as follows:

4 weeks ago X = 27 Y = 21
3 weeks ago X = 20 Y = 14
2 weeks ago X =13 Y = 7
1 week ago X = 6 Y = 0


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
ups.com...
Hello Sandy,

I tried exactly what you said but must have mis-understood something.
Here is a link to the excel file. Maybe that will shed some light on
the subject.

http://dev.shireinteractive.com/Project_Time_Karl2.xls

Thanks for your help!

Karl