Thread: Sum of Criteria within Date Range

I am trying to take the sum of a set up numbers that match several criteria. Unfortunately SUMIFS is not working and neither is SUMPRODUCT. Assuming the spreadhsheet is formatted as follows:

A B C D E
1 NAME DATE TASK QUANTITY
2 Danny 7/8/09 101 8
3 Bill 7/10/09 101 8
4 Danny 7/11/09 101 8
5 Bill 7/8/09 101 8
6 Bill 7/8/09 101 8
7 Danny 7/11/09 101 8
8 Danny 7/25/08 102 8

I created a table where I can insert a formula that would return the sum of the quantity for the task number and date range of each individual. Here is one of the formulas I tried:

=SUMIFS($E$2:$E$7, $B$2:$B$7, $B2, $d$2:$d$7,<12/31/2009&>1/1/2008, $d$2:$d$7,="101")

I do nto want to create a pivot table but would prefer to create a table arranged like this where I would be able to insert the formulas in each cell.

1/1/2008-12/31/2008 1/1/2009-12/31/2009
Danny
task 101
task 102
Bill
task 101
task 102

Thanks for your help. Attached is a spreadsheet with the data. I am trying to fill the cells between D14 and F17. As you see I was able to get the sum of the data for the Task Number and Name fields but am having trouble inputting the data range in the formula. Thanks again.