Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD UP COLUMN WITH SAME DATE
I have a list of jobs that are going to be completed on various days of the
month. I would like to know what the total is each day and then link them to a seperate summary sheet Is there some way other than physically adding them on the spreadsheet and then linking the results as jobs might move during the month Thanks Stuart |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD UP COLUMN WITH SAME DATE
Hi Stuart
Your best bet sounds like a Pivot Table. Assuming you have headers to each of your columns, place your cursor inside your data. With XL2003 DataListCreate DataPivot TableFinish Drag Date to the row area Drag Jobs to the row area Drag Jobs again, to the Data area as Count of jobs. After you have added more data to your List, when you return to the PT right clickRefresh and your report will be updated. For more help take a look at http://www.datapigtechnologies.com/ExcelMain.htm and http://www.edferrero.com/Excel Tutorials/PivotTableTutorial2003/tabbed/89/Default.aspx and http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/tiptech.html scroll to section on pivot tables -- Regards Roger Govier "Stuart WJG" wrote in message ... I have a list of jobs that are going to be completed on various days of the month. I would like to know what the total is each day and then link them to a seperate summary sheet Is there some way other than physically adding them on the spreadsheet and then linking the results as jobs might move during the month Thanks Stuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) |