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 |
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 |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com