Try:

=SUMPRODUCT((Tracking!E1:E120=(TODAY()-WEEKDAY(TODAY(),2))-27)*(Tracking!E1:E120<=(TODAY()-WEEKDAY(TODAY(),2))-21)*Tracking!D1:D120)

and Custom format as [hh]:mm for 28 days ago to 22 days ago.

Change the -27 and -21 to -20 and -14 etc. for more recent weeks

--
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,

I am putting together an excel spreadsheet to manage employee time on
projects. The last function I want to add into this sheet is the
total amount of hours they worked each week over the last 4 weeks. I
have tried to do this with a sumif statement but it appears that sumif
statements cannot have 2 conditions. What I need to do is this...

If the date on "Tracking!" (column E) falls into 22 to 28 days ago
from the first day (Monday) of this week

then add the time from column D (and the same row) and put this total
on sheet "totals!" in cell B9.

Side note - If necessary, I can have a cell that I fill in manually
that will specify the first day for that particular week since week
numbers seem to be pain in excel.

Thanks in advance for your help.

-Karl