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