Sum Data From One Spreadsheet to Another

[ridgerunner]

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

 

[Roger Govier]

Hi

Try using a Pivot table
Place your cursor anywhere inside your data table>Data>Pivot Table>Finish
on the skeleton Pivot Table that appear on a new sheet
Drag Date to the Row area
Drag name to the row area
Drag Total hours to the data area
Drag Earned Hours to the data area

Drag the Data button and drop on the Total to show hours worked and Hours
Earned side by side.

 

[ridgerunner]

Thank you Roger. I will surely give this a try.

 

[ridgerunner]

What could I do, if I need to remove the "Hours Worked" from the Data Table,
but need to capture that in another table and pull in the Earned Hours from
the Data Table?