Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same vaule
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same vaule
Enter the date you wish to total in say C1, then try this:
=SUMIF(A2:A9,C1,B2:B9) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Andy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same vaule
Maybe using the menu: Data - Subtotals
JM "Andy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same v
Thanx MAx you're a legend. :P
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same vaule
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 NextNext 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 --- "Andy" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic sum of a column when the other column has the same v
Welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 Downloads: 16,200, Files: 354, Subscribers: 53 xdemechanik --- "Andy" wrote in message ... Thanx Max you're a legend. :P |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple columns in a pivot table
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple columns in a pivot table
Suggest that you post new queries afresh
So that it's visible to all responders That's the best way to effectively use these newsgroups -- Max Singapore http://savefile.com/projects/236895 Downloads: 16,300, Files: 356, Subscribers: 53 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Negative Column | Excel Worksheet Functions | |||
Automatic Calculating % for a row of numers of the total vaule | Excel Worksheet Functions | |||
Row & column automatic highlight | Excel Discussion (Misc queries) | |||
How do I set up an automatic column select | Excel Worksheet Functions | |||
Automatic Text to column | Excel Discussion (Misc queries) |