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