Try this:

Use a cell to get the current weeks Monday date:

E1 =TODAY()-WEEKDAY(TODAY(),3)

Then:

=SUMPRODUCT(--(A1:A20=E1-28),--(A1:A20<=E1-22),B1:B20)

Biff

" wrote:

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