Automatic sum of a column when the other column has the same vaule

A

Andy

Is there an easier way to make the same date only show in one column and add
the hours of the same dates together in that column than to do it all one by
one???

Date Hours
2008/03/26 1.50
2008/03/26 7.50
2008/03/26 1.50
2008/03/27 1.00
2008/03/27 10.50
2008/03/28 8.00
2008/03/28 1.00
2008/03/28 5.00
 
M

Max

A pivot table can get you there in a matter of seconds

Assuming the table posted is in cols A & B,
data from row2 down, with real dates in col A

Steps (in xl2003)
Select any cell within the data,
click Data > PivotTable...
Click Next>Next
In step 3 of the wiz, click Layout
Drag n drop "Date" within ROW area
Drag n drop "Hours" within DATA area
Click OK > Finish. That's it!

Hop over to the pivot in the new sheet to the left,
where it'll show all the unique dates in the left col,
with corresponding total hours next to it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
 
A

Andy

Hey max your help was so good yesterday id like to ask you another question.

date total date reg date irreg
06/06/08 1.50 06/06/08 1.50 07/06/08 4.50
07/06/08 4.50 09/06/08 4.50 09/06/08 8.00
09/06/08 12.50 10/06/08 8.00 13/06/08 3.50
10/06/08 8.00 11/06/08 4.50 15/06/08 10.75
11/06/08 4.50 13/06/08 2.00 16/06/08 8.00
13/06/08 5.50 19/06/08 8.00 19/06/08 11.00
15/06/08 10.75
16/06/08 8.00
19/06/08 19.00


How do i put this into 1 pivot table so i get:
date total reg irreg
xxx xx xx xx
xxx xx xx xx
 
Top