I have data in one spreadsheet as follows:

     Date Name Task Total Hrs Worked Qty Earned Hours
     12/21/2007 AD Sort Donation Bin with Material Handling 6 8 4.6987
     12/21/2007 AS Sort Donation Bin with Material Handling 8 3 1.7620
     12/21/2007 AS 17" Monitor 8 168 5.6840
     12/21/2007 CR Sort Donation Bin with Material Handling 6 9 5.2860
     12/21/2007 LA Towers - Tear Down Only 8 40 7.1667
     12/21/2007 LD Towers - Tear Down & Material Handling 8 40 7.8733
     12/21/2007 TyS Sort Donation Bin with Material Handling 6 11 6.4607
     12/26/2007 AD Sort Donation Bin with Material Handling 8 12 7.0480
     12/26/2007 AS Sort Donation Bin with Material Handling 8 2 1.1747
     12/26/2007 AS 17" Monitor 8 209 7.0712

I need to sum part of this data in another spreadsheet as follows:

     Date Name Total Hrs Worked Total Earned Hrs
     12/21/2007 AD 6 4.6987
     12/21/2007 AS 8
     12/21/2007 CR 6
     12/21/2007 JB 6.5
     12/21/2007 LA 8
     12/21/2007 LD 8
     12/21/2007 TyS 6
     12/26/2007 AD 8
     12/26/2007 AS 8

I tried using the sumif() function, but I could use only one criteria, the
name, and I need to also the date as criteria.  I also tried the conditional
wizard, but it uses the literal values for the dates and the names,
therefore, I could not copy the formula down the "Total Earned Hours"
column.  Can someone please help with some other ideas to make this work?

tia,
ridgerunner