I'd either sort the data by the item number and then follow the data|subtotals
wizard to get the subtotals that you want--and then use the outlining symbols to
the left to hide the details.

Or I'd learn about data|Pivottables. With just a little bit of time spent
learning, you can get some very nice summary tables.

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

JCSandvik wrote:

Here is my problem. I have a list of hundreds of recurring items and want to
see a total for each.

Example

Item # Item Descrip Sold Cost
1001 Watch 10 $5
2002 Hat 5 $2
3003 Shirt 4 $3
1001 Watch 3 $5
2002 Hat 2 $2
3003 Shirt 5 $3

And I want it to read
1001 Watch 10 $5
1001 Watch 3 $5
Watch Total $65
2002 Hat 5 $2
2002 Hat 2 $2
Hat Total $14
3003 Shirt 5 $3
3003 Shirt 4 $3
Shirt Total $27

I dont need the separator line, but need the total for each product. I know
how to sort and multiply in the formula, but I can't get that total without
forcing a summation for each product.

Any help would be greatly appreciated.

--
Jeff Sandvik
Cleveland, Ohio

--

Dave Peterson