Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2000 Help
I need help with sorting mulitple items on a worksheet(data) and listing
them in a different worksheet(totals). The data is listed in columns: Name, Task, State, Cost. One name could have mulitple tasks, states and costs assigned to it. On a seperate worksheet (total) I need to have "Total Costs" by Name, task, and state. How would I do this? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2000 Help
You could use a pivot table to summarize the data, as described in Excel's
Help, or he http://www.contextures.com/xlPivot01.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Greg" wrote in message ... I need help with sorting mulitple items on a worksheet(data) and listing them in a different worksheet(totals). The data is listed in columns: Name, Task, State, Cost. One name could have mulitple tasks, states and costs assigned to it. On a seperate worksheet (total) I need to have "Total Costs" by Name, task, and state. How would I do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |